SELECT * FROM Tab1 IN [ODBC] [ODBC;Driver=SQL Server;UID=sa;PWD=;Server=127.0.0.1;DataBase=Demo;] 外部数据源连接属性的完整参数是: [ODBC;DRIVER=driver;SERVER=server;DATABASE=database;UID=user;PWD=password;]
不行,调试时报错。我的参数是,SERVER :192.168.0.3, UID:SA, PWD: 1234, DATABSE; A, TABLE: TAB1 SELECT * FROM TAB1 IN [ODBC;Driver=SQL Server;UID=sa;PWD=1234;Server=192.168.0.3;DataBase=A;]
[ODBC;Driver=SQL Server;UID=sa;PWD=;Server=127.0.0.1;DataBase=Demo;] 外部数据源连接属性的完整参数是: [ODBC;DRIVER=driver;SERVER=server;DATABASE=database;UID=user;PWD=password;]
SELECT * FROM TAB1 IN
[ODBC;Driver=SQL Server;UID=sa;PWD=1234;Server=192.168.0.3;DataBase=A;]
或者
链接服务器
试试