DTS里到了
目的(T):在下拉框里面选择
Microsoft OLE DB Provider for Oracle后
请输入服务器名:(填什么)
用户(填?)
密码参考资料:
tnsnames.ora文件:
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 205b98f1a701437)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP)
)
)
目的(T):在下拉框里面选择
Microsoft OLE DB Provider for Oracle后
请输入服务器名:(填什么)
用户(填?)
密码参考资料:
tnsnames.ora文件:
OEMREP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 205b98f1a701437)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OEMREP)
)
)
用户: (远程oracle下的用户名)
密码: (用户密码)