Developers community number 1 connection string reference

Connection strings for Caché

Providers to use when connecting to Caché

» InterSystems ODBC
» .NET Framework Data Provider for ODBC (OdbcConnection)

Finding this site useful?

-Say "Thanks" to Gonzalo Brusella and the other contributing developers!

-Thank you! »

InterSystems ODBC

Type: ODBC Driver
Usage: Driver={InterSystems ODBC}

Manufacturer: InterSystems

Customize string
example values »

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
More info about this wrapper class library »

Customize string
example values »

Bridging to InterSystems ODBC

This is just one connection string sample for the wrapping OdbcConnection class that calls the underlying ODBC Driver. See respective ODBC driver for more connection strings to use with this class.

DRIVER={InterSystems ODBC};SERVER=myServerAddress;DATABASE=myDataBase;UID=myUsername;PWD=myPassword;