1.Oracle数据库中DB-Link对象创建语法:
create public database link DB_Link_Name connect to userName identified by password using
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OTHER_SNAME)
)
)';
2.SQLServer数据库中DB-Link对象创建语法:
exec sp_addlinkedserver 'ERP' , '' , 'SQLOLEDB' , '远程服务器名或ip地址'
exec sp_addlinkedsrvlogin 'ERP' , 'false' , null , '用户名' , '密码'
exec sp_serveroption 'ERP','rpc','true';