或使用联结服务器:
EXEC sp_addlinkedserver
'别名',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
GOselect * from 别名...表名
EXEC sp_addlinkedserver
'别名',
'',
'MSDASQL',
NULL,
NULL,
'DRIVER={SQL Server};SERVER=远程名;UID=用户;PWD=密码;'
GOselect * from 别名...表名
cn1.open"driver={sql server};server=本地名;database=db_local;uid=sa;pwd=aa"
远程:
cn2.open"driver={sql server};server=远程名;database=db_server;uid=sa;pwd=bb"
操作2个数据原则可以用2个ado对象。效果是达到了,但不知这是为何?
m_pConnection->Open("driver={SQL Server};Server=ootherserver;DATABASE=vckbase;UID=sa;PWD=139","","",adModeUnknown);