Connection strings Examples for Ingres - Connectionstring Examples

Connection strings Examples for Ingres

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

Note: Please use the quota " with your specific language escape character. For example C# and C++ is \"

ODBC Driver for Ingres

This is an ODBC driver from OpenLink Software. The usage for this provider is Driver=Ingres.

DSN-Less:

Provider=MSDASQL;DRIVER=Ingres;SRVR=xxxxx;DB=xxxxx;Persist Security Info=False;Uid=yourUsername;Pwd=yourPassword;SELECTLOOPS=N;Extended Properties="SERVER=xxxxx;DATABASE=xxxxx;SERVERTYPE=INGRES";

Note: The quota " in the string needs to be escaped using your language specific escape syntax.