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