ODBC connection to Informix database from another Linux-based system

0
votes

I want to connect to an Informix database using an ODBC connection from my web server. Both Informix server and web server are implemented on different machines; both system are using SuSE Linux.

I know very well how to create an ODBC connection on the same Informix server using unixODBC.

But I don't know how to create an ODBC connection from one Linux based machine to another machine where the Informix server is implemented.

If I use Windows 7 instead of Linux then Windows 7 provides ODBC connection template and there is also no problem in connectivity.

But how to do it with a client PC running Linux OS.

Please guide me.

1
linuxodbcinformix
Could it be a keyboard problem ? – Paul R
how it could be a keyboard problem Please describe it. My web server is PHP based. – JITENDRA KUMAR
Anybody????? Please help me – JITENDRA KUMAR

1 Answers

0
votes

If you can connect from one Linux machine to Informix database using ODBC then you have installed Informix ODBC client and one of ODBC managers. Such manager can be UnixODBC, Informix own manager or something else. On Linux those managers use odbc.ini and odbcinst.ini configuration files where you configure driver and connection.

Check how it is configured on Linux machine where it works: find those .ini files, check environmet variables (INFORMIXDIR and INFORMIXSQLHOSTS) and find ODBC manager (UnixODBC?). If you use UnixODBC then you can test connection with its isql utility.

Good info abour configuring Informix ODBC client on Linux can be found at: http://www.ibm.com/developerworks/data/library/techarticle/dm-1108odbcdrivermanager/