在VS2005中连接数据库SQL2000字符串
<connectionStrings>
<add name= "SimpleOAConnectionString " connectionString= "
DataSource=CGJ\SQLEXPRESS;
Initial Catalog=SimpleOA;
Integrated Security=True " providerName= "System.Data.SqlClient "/>
</connectionStrings>
这是连接SQL2005的,要连接SQL2000应该怎么写呢?
------解决方案-------------------- <connectionStrings>
<add name= "SimpleOAConnectionString " connectionString= "
DataSource=机器名\实例名;
Initial Catalog=SimpleOA;
Integrated Security=True " providerName= "System.Data.SqlClient "/>
</connectionStrings>
一样的,只不过,使用vs2005连接sql2000得把sql2000加一个sp4补丁包
个人见解,共同学习
------解决方案-------------------- <connectionStrings>
<add name= "SimpleOAConnectionString " connectionString= "
Server=机器名\实例名;
Database=SimpleOA;
UserID=SA;
PWD=******;
providerName= "System.Data.SqlClient "/>
</connectionStrings>