Microsoft.Data.Access.Application.Block for OleDB

[Guest]

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]

Go search for the MS Access Data Application Block, its out there. Last
time I saw it was on www.gotdotnet.com

 

[Guest]

I have that...

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

Any other ideas???

Thanks