dbserver 安装了两个不同版本的数据库 ,sqlserver7 and sqlserver2000 ?? 请问楼主是如何将SQLSERVER7.0和2000同时启动的!!!!
you can try below to connection on instance in remote server: Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DB_NAME Data Source=10.167.37.149
thank you 黄山光明顶 ,i try ,but fail , i copy the tables and views to another db in sqlserver7 from sqlserver2000 , user the connectionstring:provider=sqloledb;Data Source=computername;Initial Catalog=databasename;User Id=userid;pwd=*** ,say thank to everyone!!
请问楼主是如何将SQLSERVER7.0和2000同时启动的!!!!
Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=DB_NAME Data Source=10.167.37.149