IBM Informix .NET Provider
Set up an ODBC data source on Windows Set up an ODBC data source on Linux You can configure an ODBC data source to connect to your Informix database from ArcGIS clients, or you can provide a connection string, which includes the Informix host, server, port, and database information. Solved: Hello, I have been trying all day to get an ODBC connection to our new informix server. I installed the IBM Informix ODBC Driver for 64bit and ran the odbc in 32 bit. DataDirect for IBM Informix improves performance and scalability, reduces deployment and maintenance costs, reinforces your security strategy and ensures high availability.
Standard
Database=myDataBase;Host=192.168.10.10;Server=db_engine_tcp;Service=1492;
Protocol=onsoctcp;UID=myUsername;Password=myPassword;
![Informix Informix](https://www.easyfrom.net/articles/connect_to_informix/images/informix_source.png)
↯ Problems connecting?
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
Informix Odbc Connection String Examples
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;