IBM Informix .NET Provider
Standard
Database=myDataBase;Host=192.168.10.10;Server=db_engine_tcp;Service=1492;Protocol=onsoctcp;UID=myUsername;Password=myPassword;
Informix connection strings
IBM Informix OLE DB Provider
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
Use an OLE DB provider from .NET
Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;
IBM Informix ODBC Driver
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
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
Use an ODBC driver from .NET
Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;
Luxena dbExpress driver for Informix Pro
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;