Connection strings for Informix
Providers for Informix
Community Forums
Find solutions and post questions regarding connection string related issues.
IBM Informix .NET Provider
Type
.NET Framework Class Library
Usage IBM.Data.Informix.IfxConnection
Manufacturer IBM
Usage IBM.Data.Informix.IfxConnection
Manufacturer IBM
Standard
Database=myDataBase;Host=192.168.10.10;Server=db_engine_tcp;Service=1492; Protocol=onsoctcp;UID=myUsername;Password=myPassword;
Luxena dbExpress driver for Informix Pro
Type
Native driver
Usage
Manufacturer Luxena
Usage
Manufacturer Luxena
Standard
The connection string is provided through the "HostName" parameter that exists in TSQLConnection.Params collection.
InformixServer=myServerAddress;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;
Standard dbExpress configuration parameters have higher priority against connection string parameters.
IBM Informix OLE DB Provider
Type
OLE DB Provider
Usage Provider=Ifxoledbc
Manufacturer IBM
Usage Provider=Ifxoledbc
Manufacturer IBM
Standard
Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;Password=myPassword;
Persisting security info in the connection string
Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;Password=myPassword;Persist Security Info=true;
.NET Framework Data Provider for OLE DB
Type
.NET Framework Wrapper Class Library
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Usage System.Data.OleDb.OleDbConnection
Manufacturer Microsoft
Bridging to IBM Informix OLE DB Provider
This is just one connection string sample for the wrapping OleDbConnection class that calls the underlying OLEDB provider. See respective OLE DB provider for more connection strings to use with this class.
Provider=Ifxoledbc;Data Source=dbName@serverName;User ID=myUsername;Password=myPassword;
IBM Informix ODBC Driver
Type
ODBC Driver
Usage Driver={INFORMIX 3.30 32 BIT}
Manufacturer IBM
Usage Driver={INFORMIX 3.30 32 BIT}
Manufacturer IBM
Informix 3.30
Dsn='';Driver={INFORMIX 3.30 32 BIT};Host=hostname;Server=myServerAddress;Service=service-name;Protocol=olsoctcp;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Informix-CLI 2.5
Type
ODBC Driver
Usage Driver={Informix-CLI 2.5 (32 Bit)}
Manufacturer IBM
Usage Driver={Informix-CLI 2.5 (32 Bit)}
Manufacturer IBM
Informix-CLI 2.5:
Driver={Informix-CLI 2.5 (32 Bit)};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
.NET Framework Data Provider for ODBC
Type
.NET Framework Wrapper Class Library
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Usage System.Data.Odbc.OdbcConnection
Manufacturer Microsoft
Bridging to Informix-CLI 2.5 (32 Bit) ODBC Driver
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={Informix-CLI 2.5 (32 Bit)};Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Selected Articles