Connection strings for Caché
ODBC drivers for Caché
.NET libraries for Caché
InterSystems ODBC
Type
ODBC Driver
Usage Driver={InterSystems ODBC}
Manufacturer InterSystems
Usage Driver={InterSystems ODBC}
Manufacturer InterSystems
Standard
DRIVER={InterSystems ODBC};SERVER=myServerAddress;DATABASE=myDataBase;UID=myUsername;PWD=myPassword;
Specifying port
DRIVER={InterSystems ODBC};SERVER=myServerAddress;PORT=12345;DATABASE=myDataBase;UID=myUsername;PWD=myPassword;
Specifying protocol
DRIVER={InterSystems ODBC};SERVER=myServerAddress;PORT=12345;DATABASE=myDataBase;PROTOCOL=TCP;STATIC CURSORS=1;UID=myUsername;PWD=myPassword;
.NET Framework Data Provider for ODBC
Type
.NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Use an ODBC driver from .NET
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;
See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.