Re: Informix odbc driver and unix odbc

For those who 're interested in the solution: There is a problem of supporting Informix ODBC driver by unixODBC. It can be solved if you download ansi version of the driver unixODBC-2.2.5-ansi.tar.gz from ftp.easysoft.com/pub/unixODBC. I contacted Nick Gorham who pointed me in the right direction. I tested the version and it works with informix driver (you still can't configure DSN via ODBCConfig or DataManager but you can do that by manually editing odbc.ini and odbcinst.ini files). Thanks to all who was trying to help. -- 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 * ********************************************************************* Boris Niyazov 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 * > *********************************************************************