Informix ODBC Driver For NT?
Posted in 2000
Topics: Connectivity: ODBC / JDBC / .NET
Hey Folks... Is there such a beast? The reason I ask, is that I've been able to configure the Informix 32-bit ODBC driver on my Windows 98 machine and get connectivity, but when I put the same driver on our Web Server (NT4), I keep getting an error of "cannot open file SQL.iem" -461. The setup on the web server & windows 98 machine are the same for that driver. The sql.iem file is in the path of both machines and does exist. THanks for your help!
Check for INFORMIXDIR environment variable - it must to point on root of informix directory structure. Check for DBLANG environment variable - it must be EN_US.1252 (for M$ WIN). Good luck. Sergey. Michael Dempsey <mdempse.isd1@mail.unch.unc.edu> ''''' ' ''''''''':39f99425.156742214@news.oit.unc.edu... > Hey Folks... > Is there such a beast? The reason I ask, is that I've been able > to configure the Informix 32-bit ODBC driver on my Windows 98 machine > and get connectivity, but when I put the same driver on our Web Server > (NT4), I keep getting an error of "cannot open file SQL.iem" -461. > The setup on the web server & windows 98 machine are the same for that > driver. The sql.iem file is in the path of both machines and does > exist. THanks for your help!
I'm using the same ODBC drivers (as part of CSDK) for both WinNT and Win9x. Your ODBC driver environment is not configured properly. Control Panel/System/Environment Make sure $INFORMIXDIR/BIN is in your (or SYSTEM) PATH string. Set INFORMIXDIR Run regcopy. Hope this helps, Sergey "Michael Dempsey" <mdempse.isd1@mail.unch.unc.edu> wrote in message news:39f99425.156742214@news.oit.unc.edu... > Hey Folks... > Is there such a beast? The reason I ask, is that I've been able > to configure the Informix 32-bit ODBC driver on my Windows 98 machine > and get connectivity, but when I put the same driver on our Web Server > (NT4), I keep getting an error of "cannot open file SQL.iem" -461. > The setup on the web server & windows 98 machine are the same for that > driver. The sql.iem file is in the path of both machines and does > exist. THanks for your help!
On Sat, 28 Oct 2000 07:49:43 -0000, "Sergey E. Volkov" <sve@raiden.bancorp.ru> wrote: >Check for INFORMIXDIR environment variable - it must to point on root of >informix directory structure. On the PC! >Check for DBLANG environment variable - it must be EN_US.1252 (for M$ WIN). Why should he need it on the NT machine and not on the 98 one? > >Good luck. > >Sergey. > >Michael Dempsey <mdempse.isd1@mail.unch.unc.edu> ''''' ' >''''''''':39f99425.156742214@news.oit.unc.edu... >> Hey Folks... >> Is there such a beast? The reason I ask, is that I've been able >> to configure the Informix 32-bit ODBC driver on my Windows 98 machine >> and get connectivity, but when I put the same driver on our Web Server >> (NT4), I keep getting an error of "cannot open file SQL.iem" -461. >> The setup on the web server & windows 98 machine are the same for that >> driver. The sql.iem file is in the path of both machines and does >> exist. THanks for your help! > What ODBC driver are you trying to use? The one from the Informix Windows SDK?
> On the PC! I didn't say 'root', I has said 'root of Informix's directory structure'. > Why should he need it on the NT machine and not on the 98 one? On both NT and 9x you can to leave it blank or 'EN_US.1252'. Sally Woolrich <sally.woolrich@comino.com> ''''' ' ''''''''':39fd4245.326453595@comino-leeds... > On Sat, 28 Oct 2000 07:49:43 -0000, "Sergey E. Volkov" > <sve@raiden.bancorp.ru> wrote: > > >Check for INFORMIXDIR environment variable - it must to point on root of > >informix directory structure. > > On the PC! > > >Check for DBLANG environment variable - it must be EN_US.1252 (for M$ WIN). > Why should he need it on the NT machine and not on the 98 one? > > > > >Good luck. > > > >Sergey. > > > >Michael Dempsey <mdempse.isd1@mail.unch.unc.edu> ''''' ' > >''''''''':39f99425.156742214@news.oit.unc.edu... > >> Hey Folks... > >> Is there such a beast? The reason I ask, is that I've been able > >> to configure the Informix 32-bit ODBC driver on my Windows 98 machine > >> and get connectivity, but when I put the same driver on our Web Server > >> (NT4), I keep getting an error of "cannot open file SQL.iem" -461. > >> The setup on the web server & windows 98 machine are the same for that > >> driver. The sql.iem file is in the path of both machines and does > >> exist. THanks for your help! > > > > What ODBC driver are you trying to use? The one from the Informix > Windows SDK? >