当前位置:数据库 > SQLServer >>

创建DBlinksql

创建DBlinksql
 
create database link jjlink 
connect to 用户民 identified by 密码 
using '(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.54)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SERVICE_NAME = 实例名) 
) 
)';

 


Oracle
MySQL
Access
SQLServer
DB2
Excel
SQLite
SYBASE
Postgres
如果你遇到数据库难题:
请访问www.zzzyk.com 试试
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,