Realaxed


Hello,

I'm trying to create a web page that is protected by a user login. I want the user data to be stored in an access database file and not an SQL Server express database.

I was following this guide on msdn:

http://msdn2.microsoft.com/en-us/library/879kf95c(VS.80).aspx

However, I was doing everything locally using a file system and not IIS. (Which seemed to work fine)

My main problem is that I cannot get the membership information stored in an access database. The only provider option was one for the SQL server express. I think I will have to make a custom provider However, I read through some of that documentation and was equally confused. ( http://msdn2.microsoft.com/en-us/library/Aa479031.aspx )

Anyone have a solution




Re: Store Membership information using Access .mdb database

Caddre


There is an Access Membership provider created for Access 2003 and below, you can get it in the link below on the right in download but it is only in C# so if you need VB you can look for code converter to convert the code to VB. Hope this helps.

http://msdn2.microsoft.com/en-us/asp.net/aa336558.aspx







Re: Store Membership information using Access .mdb database

Realaxed

Hi Caddre

Thanks for your reply.

I actually do need it in VB. I tried using an online converter,but the converter itself is has errors.

I used this converter: http://www.developerfusion.co.uk/utilities/convertcsharptovb.aspx

and recieved these errors.

Conversion was completed, however the following errors were reported:
-- line 255 col 65: Out parameter converted to ByRef
-- line 1176 col 89: Out parameter converted to ByRef
-- line 1299 col 117: Out parameter converted to ByRef
-- line 1387 col 115: Out parameter converted to ByRef
-- line 1480 col 91: Out parameter converted to ByRef
-- line 1491 col 91: Out parameter converted to ByRef
-- line 1505 col 59: Out parameter converted to ByRef
-- line 1506 col 51: Out parameter converted to ByRef
-- line 1507 col 43: Out parameter converted to ByRef
-- line 1508 col 52: Out parameter converted to ByRef

Are these errors significant

I would post the converted code, but it's abit much and I'm not sure if it would be allowed.






Re: Store Membership information using Access .mdb database

Caddre

Try this one it is better than the one you used, if you still get errors then post the code conversion issue on both VB and C# forums other user can help you with the conversion.

http://www.carlosag.net/Tools/CodeTranslator/Default.aspx






Re: Store Membership information using Access .mdb database

Realaxed

Great. Thanks again Caddre. The converter worked and didn't give me any errors.

Now I have a file named 'AccessMembershipProvider.vb'

I'm now trying to understand what I have to do so that this file it is picked up by the "ASP.net Web site Administration Tool" once I view the "provider" tab.

Any advice for that is also welcome. Thanks so far.





Re: Store Membership information using Access .mdb database

Caddre

All you need is covered in the link below.

http://www.devx.com/asp/Article/29256/0/page/1