change the default data management provider

topherdude · July 14th, 2007, 12:46 AM

Apologies if this have been asked beforeâ¦

How do I use the change the default site data management provider? I am converting my site to asp.net 2.0 and my user data is in SQL, I would like to take advantage of the built-in login controls. I used the aspnet_regsql wizard, which created about ten tables in my SQL database. So now what? I am using Visual Web Developer 2005 and I go to the web app admin screen to choose a data provider, but my only choice is the default; AspNetSqlProvider. What is my next step?

Imar · July 14th, 2007, 03:17 AM

Hi there,

If you want to access your own data in your existing database, you need to write a custom provider. You can use the standard SQL version as a starting point. Check out the following two articles for more information:

http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=380
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=404

Cheers,

Imar

---------------------------------------
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.