Microsoft.Data.Access.Application.Block for OleDB

Discussion in 'ASP .Net' started by =?Utf-8?B?VGltOjouLg==?=, Jun 8, 2006.

  1. Can someone tell me how you change this code for an Oledb connection rather
    than SQL Server. The code currently uses
    Microsoft.Data.Access.Application.Block and the SQLHelper object...

    I need to use this with an access database!

    reader =
    SqlHelper.ExecuteReader(ConfigurationSettings.AppSettings("strConn"),
    CommandType.StoredProcedure, "rolesForUser", New OleDbParameter("@Username",
    User.Identity.Name))

    Thanks for any help!
    =?Utf-8?B?VGltOjouLg==?=, Jun 8, 2006
    #1
    1. Advertising

  2. =?Utf-8?B?VGltOjouLg==?=

    tdavisjr Guest

    Go search for the MS Access Data Application Block, its out there. Last
    time I saw it was on www.gotdotnet.com
    ... wrote:
    > Can someone tell me how you change this code for an Oledb connection rather
    > than SQL Server. The code currently uses
    > Microsoft.Data.Access.Application.Block and the SQLHelper object...
    >
    > I need to use this with an access database!
    >
    > reader =
    > SqlHelper.ExecuteReader(ConfigurationSettings.AppSettings("strConn"),
    > CommandType.StoredProcedure, "rolesForUser", New OleDbParameter("@Username",
    > User.Identity.Name))
    >
    > Thanks for any help!
    tdavisjr, Jun 8, 2006
    #2
    1. Advertising

  3. I have that...

    But it doesn't work with Access Database connections (OleDB)

    Any other ideas???

    Thanks


    "tdavisjr" wrote:

    > Go search for the MS Access Data Application Block, its out there. Last
    > time I saw it was on www.gotdotnet.com
    > ... wrote:
    > > Can someone tell me how you change this code for an Oledb connection rather
    > > than SQL Server. The code currently uses
    > > Microsoft.Data.Access.Application.Block and the SQLHelper object...
    > >
    > > I need to use this with an access database!
    > >
    > > reader =
    > > SqlHelper.ExecuteReader(ConfigurationSettings.AppSettings("strConn"),
    > > CommandType.StoredProcedure, "rolesForUser", New OleDbParameter("@Username",
    > > User.Identity.Name))
    > >
    > > Thanks for any help!

    >
    >
    =?Utf-8?B?VGltOjouLg==?=, Jun 8, 2006
    #3
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Showjumper
    Replies:
    4
    Views:
    392
    Showjumper
    Jan 26, 2004
  2. RobT
    Replies:
    2
    Views:
    325
  3. Alex Smotritsky

    Microsoft Data Access Application Block

    Alex Smotritsky, Apr 15, 2004, in forum: ASP .Net
    Replies:
    1
    Views:
    402
    Rick Spiewak
    Apr 23, 2004
  4. Showjumper
    Replies:
    1
    Views:
    690
    Showjumper
    Mar 19, 2005
  5. morrell
    Replies:
    1
    Views:
    933
    roy axenov
    Oct 10, 2006
Loading...

Share This Page