Informix Connection strings - Connectionstring Examples

Connection strings Examples for Informix

IBM Informix .NET Provider

This is a .NET Class Library from IBM. The namespace for this library is IBM.Data.Informix.IfxConnection

Standard Security:

Database=yourDataBase;Host=192.168.10.10;Server=db_engine_tcp;Service=1492; Protocol=onsoctcp;UID=yourUsername;Password=yourPassword;

IBM Informix OLE DB Provider

This is a OLE DB Provider from IBM. The usage for this provider is Provider=Ifxoledbc.

Standard Security:

Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=yourUsername;Password=yourPassword;

You can view more OLE DB connection strings for other data provider from other pages.

Persisting security info in the connection string:

Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=yourUsername;Password=yourPassword;Persist Security Info=true;

You can view more OLE DB connection strings for other data provider from other pages.

Luxena dbExpress driver for Informix Pro

This is a native driver from Luxena. The namespace for this library is Npgsql.NpgsqlConnection

More information on this provider from Luxena.

Standard Security:

InformixServer=yourServerAddress;Client_Locale=en_us.8859-1;Fet_Buf_Size=32767;OptOFC=1;AutoCommit=True;BlobSize=-1;WaitOnLocks=False;CommitRetain=False;IsolationLevel=ReadCommitted;Trim Char=False;money=currency;decimal=bcd;int8=fmtbcd;lvarchar=string;

Use the "HostName" parameter to provide the connection string and it exists in TSQLConnection.Params collection.

.NET Framework Data Provider for OLE DB

This is an .NET class library from Microsoft. The namespace for this provider is System.Data.OleDb.OleDbConnection.

Standard Security:

Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=yourUsername;Password=yourPassword;

You can view more OLE DB connection strings for other data provider from other pages.

IBM Informix ODBC Driver

This is an ODBC driver from IBM. The usage for this driver is Driver={INFORMIX 3.30 32 BIT} .

Standard Security:

Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=yourServerAddress;Service=service-name;Protocol=olsoctcp;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

Informix-CLI 2.5 ODBC Driver

This is an ODBC driver from IBM. The usage for this driver is Driver={Informix-CLI 2.5 (32 Bit)}.

Standard Security:

Driver={Informix-CLI 2.5 (32 Bit)};Server=yourServerAddress;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;