创建一个KDB库,建立dblink,需要在KDB库内访问KINGBASE库中的数据;
KINGBASE=#CREATE DATABASE KDB
[kingbase@localhost config]$ vim sys_dblink.conf
[kingbase]
DriverType=ODBC
DriverName="KingbaseES
7 ODBC Driver"
Host=127.0.0.1
Port=54321
dbname=KINGBASE
#dbname=REGRESSION
ExtendedProperties="UseServerCursor=1;Fetch=1000"
<