Caché 数据库及CIS连接字符串

一、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;