Re: 16-bit CLI ODBC and IIS 4.0 - getting error IM003 [Microsoft][ODBC

Michael Bellinger wrote: > > Hi, > > I try to connect via an CGI-application (running on a NT - Internet > Information Server 4.0) to an Informix datasource on a remote server and > get the following error message: > > The application uses the 16bit Informix-CLI 2.5 for ODBC. > > The mystery is, that when I use the application itself, everything works > well!! Only when the app is used via OLE by the Internet Information > Server, the error occurs. > > (Note: IIS 4.0 works as a process - not a service, so the user who is > logged on (not IUSR_computername) starts the SQLConnect. All ini-files > (informix.ini, odbc.ini) can be reached within the PATH-variable.) > > Maybe the message text "specified driver could not be loaded" is > misleading!? > > Any hints on that? - Thanks!!! > > Michael Bellinger Hi, Michael Dunno if this helps much but the only way I saw the error "Specified driver could not be loaded" come up is when the $INFORMIXDIR$/bin directory was not in the search path. I would bet that it has something to do with this. Maybe it would be worth trying to output your PATH setting in the beginning of your CGI script and hence observing in what context it actually runs. Best luck, Dirk -- -- Dirk Gunsthoevel phone: +49 (0)251 624947 -- Hoeftestr.49 fax: +49 (0)251 624177 -- 48167 Muenster mobile: +49 (0)170 5464715 -- Germany http://members.aol.com/Plabit

Dirk Gunsthoevel wrote in message <7pjdcc$qdh$1@news.xmission.com>... >> I try to connect via an CGI-application (running on a NT - Internet >> Information Server 4.0) to an Informix datasource on a remote server and >> get the following error message: >> >> The application uses the 16bit Informix-CLI 2.5 for ODBC. The answer is simple: -- don't use the 16-bit ODBC driver/CLI -- the OLE DB Provider and IIS require 32-bit ODBC drivers ========================================================== Database Magic with Ken North (the first book to explain Java in the database) http://ourworld.compuserve.com/homepages/Ken_North/dbmagic.htm

The application requires 16-bit CLI! IIS4 is running as a process (not a service) and uses the (16-bit-) application via OLE. Michael Ken North wrote: > The answer is simple: > -- don't use the 16-bit ODBC driver/CLI > -- the OLE DB Provider and IIS require 32-bit ODBC drivers > > ========================================================== > Database Magic with Ken North > (the first book to explain Java in the database) > http://ourworld.compuserve.com/homepages/Ken_North/dbmagic.htm