Does anyone know where to find a simple sample code that uses asp.net 2.0 and SQL 2000 to

Does anyone know where to find a simple sample showing you how to use asp.net 2.0 with the login control to direct you to another aspx page using SQL 2000 as the database on a hosted server? I have been beating my head against the wall trying to figure this out and would be very appreciative if anyone knows a place out there that shows this? I can find many sites that show you how to do this with SQL 2005, but not SQL 2000. Thanks - Chris

Hello:

Actually, for this part you can follow along with this article.

http://aspnet.4guysfromrolla.com/articles/040506-1.aspx

The key is how to connect to an existing database using the ASP.NET SQL Server Registration Tool (aspnet_regsql.exe).

You can find this tool in your ASP.NET 2.0 installation folder:%WINDOWS%\Microsoft.NET\Framework\v2.0.50727

Hope this gives a start point. I ran this tool before and I cannot remember there is any difference compare to SQL Server 2005 Dev version. Express is a little different as you've already found out.

|||

It seems the link in previous post is about sql 2005 so I find another link :

how do I setup the new ASP.NET Membership, Role Management, and Personalization services to use a regular SQL Server instead of SQL Express

Hope it helps.

|||Actually I was looking for some sample code that has the connect string and what not. I have already read that, I keep getting errors on my host website. Mainly when trying to login. Anyone?|||

Could you show your error message ?

You can find different connection stringhere.