Connection strings Examples for Cache - Connectionstring Examples

Connection strings Examples for Cache

.NET Data Provider for ODBC

This is a .NET Class Library from Microsoft. The namespace for this provider is System.Data.Odbc.OdbcConnection.

Standard:

DRIVER={InterSystems ODBC};SERVER=yourServerAddress;DATABASE=yourDataBase;UID=yourUsername;PWD=yourPassword;

Note: You can view more ODBC connection strings for other data provider from other pages.

InterSystems ODBC

This is a ODBC driver from Teradata. The usage for this provider is Provider=Teradata.

Standard:

DRIVER={InterSystems ODBC};SERVER=yourServerAddress;DATABASE=yourDataBase;UID=yourUsername;PWD=yourPassword;

Specifying port:

DRIVER={InterSystems ODBC};SERVER=yourServerAddress;PORT=12345;DATABASE=yourDataBase; UID=yourUsername;PWD=yourPassword;

Specifying protocol:

DRIVER={InterSystems ODBC};SERVER=yourServerAddress;PORT=12345;DATABASE=yourDataBase;PROTOCOL=TCP;STATIC CURSORS=1;UID=yourUsername;PWD=yourPassword;