Connection strings for Ingres

Providers to use when connecting to Ingres

» ODBC Driver for Ingres
» .NET Framework Data Provider for ODBC (OdbcConnection)

Finding this site useful?

-Say "Thanks" to Mario Ciappara and the other contributing developers!

-Thank you! »

ODBC Driver for Ingres

Type: ODBC Driver
Usage: Driver=Ingres

Manufacturer: OpenLink Software

Customize string
example values »

DSN-less

Provider=MSDASQL;DRIVER=Ingres;SRVR=xxxxx;DB=xxxxx;Persist Security Info=False;Uid=myUsername;Pwd=myPassword;SELECTLOOPS=N;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
More info about this wrapper class library »

Customize string
example values »

Bridging to ODBC Driver for Ingres

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=Ingres;SRVR=xxxxx;DB=xxxxx;Persist Security Info=False;Uid=myUsername;Pwd=myPassword;SELECTLOOPS=N;Extended Properties="SERVER=xxxxx;DATABASE=xxxxx;SERVERTYPE=INGRES";