一、Caché InterSystems ODBC
1.标准连接字符串
DRIVER={InterSystems ODBC};SERVER=myServerAddress;DATABASE=myDataBase;UID=myUsername;PWD=myPassword;
2.指定端口
DRIVER={InterSystems ODBC};SERVER=myServerAddress;PORT=12345;DATABASE=myDataBase;UID=myUsername;PWD=myPassword;
3.指定协议
DRIVER={InterSystems ODBC};SERVER=myServerAddress;PORT=12345;DATABASE=myDataBase;PROTOCOL=TCP;STATIC CURSORS=1;UID=myUsername;PWD=myPassword;
二、Caché .NET Framework Data Provicer for ODBC
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;
三、CIS Composite ODBC连接
1. DNS 连接方式
Driver=Composite 4.5;HOST=myServerAddress;PORT=9501;UID=myUsername;PWD=myPassword;DOMAIN=composite;DATASOURCE=PDSI;
2.指定目录连接方式
Driver=Composite 4.5;HOST=myServerAddress;PORT=9501;Catalog=myCatalog;UID=myUsername;PWD=myPassword;DOMAIN=composite;DATASOURCE=PDSI;
四、 CIS .NET Framework Data Provider for ODBC
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;