Re: Informix odbc driver and unix odbc
Hi Boris One rather rough solution would be to simply link the db client application directly with the Informix driver instead of unixODBC. This is possible in most cases since they share the same set of functions according to the ODBC standard. But it may be hard if the application is rebuild to link with unixODBC... I wanted to connect to Informix 9.3 on my Linux (both client and server running on Linux) and use the same ODBC calls as in the Windows environment. Since I had little knowledge about ODBC for Linux at the time, I simply linked my multithreaded C programs directly with the driver by adding the following options in my makefile: MYODBCLIBS = -L$(INFORMIXDIR)/lib/esql -lifgls -lifglx MYODBCFLAGS = -DIFX_THREAD -DIFX_DCE Just a shot in the dark... Regards, Thomas Speed of Mind On Tue, 20 May 2003 14:00:08 -0400, Boris Niyazov <niyazov@solni.law.columbia.edu> wrote: >Hi everyone, > >how can I configure informix odbc driver (3.81) to work under unix odbc >on rh 7.3 linux? Looks like the odbc manager does not recognize the >driver. It's unable to read the the driver's attributes to configure DSN >using ODBCConfig, for example. I tried to configure odbcinst.ini and >odbc.ini manually, but still using UNIX ODBC isql utility I am not able >to connect ( I get ISQL Error: Could not SQLConnect. The log shows >Exit: [SQL_INVALID_HANDLE] in SQLConnect.c). > >However if I use informix demo c programms supplied with the ODBC driver >they work ok. > >The issue we're having is that our notes developers use >unixODBC resources to connect to the database. >We have Informix online 7.31 and unixODBC 2.2.5 and client SDK >281-UC1-Linux. > >Your help will be appreciated. > >Thanks, > > -- Boris > >********************************************************************* >* Boris Niyazov Ph: 212-854-4094 Fax: 212-854-1749 * >* Systems Manager Email: ban5@columbia.edu * >* Columbia Law School URL: http://www.law.columbia.edu * >********************************************************************* > >