原使用server端使用 win 2000 server+sql 2000 server而 client端使用win 2000 server 可以正常存取sql 2000 Server , 但client端也安裝上sql 2000 server後便clinet端無法連至server端存取, 而server端還是可正常工作.adodc連線設定如下(2種)
1---＞CONNECTIONSTRING="DSN=XXX;USER ID=ZZZ;PASSWORD=KKK" (XXX為ODBC ZZZ為SQL USER,KKK為SQL PASSWORD)
2---＞CONNECTIONSTRING="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persit Security Info=false;User ID=xxxx;Initial Catalog=zzz;Data Source=yyy" (xxx為sql user zzz為DatabaseName yyy為ServerName)
1---＞CONNECTIONSTRING="DSN=XXX;USER ID=ZZZ;PASSWORD=KKK" (XXX為ODBC ZZZ為SQL USER,KKK為SQL PASSWORD)
2---＞CONNECTIONSTRING="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persit Security Info=false;User ID=xxxx;Initial Catalog=zzz;Data Source=yyy" (xxx為sql user zzz為DatabaseName yyy為ServerName)