Wednesday, March 7, 2012

Can ASP.net 2.0 be connected with SQL Server 2000?

using vs2005 to build web pages of asp.net 2.0, The database is SQL Server 2000,.But I always fail to connect.

using the following configuration in web.config:

<appSettings>
<add key="DSN_student" value="server=(local);uid=admin;pwd=123456;database=network_course"/>
</appSettings>

I also failed to connect using the following configuration in web.config:

<add name="network_courseConnectionString1" connectionString="Data Source=(local);Initial Catalog=network_course;User ID=admin;Password=123456;"
providerName="System.Data.SqlClient" />

I am a beginner from China and eager to get answers! Thank you!

Can you post the error you got and the code?

Regards

|||To answer your question, yes. You can use VS2005 with SQL Server 2000. Looking at your second connection string seems like it should work. You might add "Integrated Security=false" in the connect string attributes, but I believe that is the default.

No comments:

Post a Comment