Re: Informix odbc driver and unix odbc
Hi Thomas, The thing is that our lotus notes team moves their code from windows to linux. The existing lotus script application relies on odbcmanager and worked well on windows. The developers are saying that they need to rewrite big portion of code to make direct connection to Informix, and they do not have time and desire to do that. I am not an expert in lotus notes, and can't say if it's a big deal to do what you can easily do in C :-) Thanks for your response, anyway. -- Boris Thomas Rask wrote: > 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 * > >********************************************************************* > > > > *******
Boris It sounds to like all you need is an ODBC driver Manager and an ODBC driver. You simply then get your application to use a datasource to connect to your database. I don't really believe it will be a big problem unless there's something else I'm missing here Emmon Boris Niyazov <niyazov@solni.law.columbia.edu> wrote in message news:<3ECCFD7B.15411758@solni.law.columbia.edu>... > Hi Thomas, > > The thing is that our lotus notes team moves their code from windows to > linux. The existing lotus script application relies on odbcmanager and > worked well on windows. The developers are saying that they need to rewrite > big portion of code to make direct connection to Informix, and they do not > have time and desire to do that. I am not an expert in lotus notes, and > can't say if it's a big deal to do what you can easily do in C :-) > > Thanks for your response, anyway. > > -- Boris > > Thomas Rask wrote: > > > 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 * > > >********************************************************************* > > > > > > > > *******