Connection strings for Ingres

Ingres .NET Data Provider

Type .NET Framework Class Library
Usage Ingres.Client.IngresConnection
Manufacturer Actian Corporation

Current User

Use the current user's credentials and the default port, II7.


Explicit Port Specified


Specific User


ODBC Driver for Ingres

Type ODBC Driver
Usage Driver=Ingres
Manufacturer OpenLink Software


Provider=MSDASQL;DRIVER=Ingres;SRVR=xxxxx;DB=xxxxx;Persist Security Info=False;
Extended Properties="SERVER=xxxxx;DATABASE=xxxxx;SERVERTYPE=INGRES";

Important note!
The quota " in the string needs to be escaped using your language specific escape syntax.
c#, c++   \"
VB6, VBScript   ""
xml (web.config etc)   "
or maybe use a single quota '.


.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
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.