ADO 连接SQL Server 2000的有关问题
ADO 连接SQL Server 2000的问题
SQL Server 2000试了很多连接方法，但总是出现错误，如下这句出现IDispacth error #3187
m_pConnection->Open("Provider = SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info = fasle;Data Source = (local); Initial Catalog = MouseTest;uid = sa;pwd = 1234","","",adModeUnknown);
------解决方案--------------------
m_pConnection->Open("Driver=SQL Server;Server=172.28.4.138;DataBase=pubs;Uid=sa;Pwd=1234;","","",adModeUnknown);
SQL Server 2000试了很多连接方法，但总是出现错误，如下这句出现IDispacth error #3187
m_pConnection->Open("Provider = SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info = fasle;Data Source = (local); Initial Catalog = MouseTest;uid = sa;pwd = 1234","","",adModeUnknown);
------解决方案--------------------
m_pConnection->Open("Driver=SQL Server;Server=172.28.4.138;DataBase=pubs;Uid=sa;Pwd=1234;","","",adModeUnknown);