Informix ODBC Problems
Alexander Schwinn got an ODBC error (unable to load locale categories) opening an Informix CLI 2.5 connection from ASP; after adding Microsoft KB registry keys he got 'unknown Informix username'. mp suggested testing with the ilogin demo and adding sqlexec 1525/tcp to services; Sergey Turin advised setting INFORMIXDIR and PATH or reinstalling. Alexander found Access worked and suspected the IIS IWAM user. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi, I'm using an ODBC-Connection to an Informix Database in my ASP's. (Informix CLI 2.5 32 Bit) When I'm trying to open a connection (Conn.Open ...), the following error occurs: [ODBC... unable to load locale categories). I found an article in the Microsoft KB (http://support.microsoft.com/support/kb/articles/Q166/4/41.ASP?LN=EN-US&SD=SO&FR=0). So I created the registry keys but now there is another error: ...unknown Informix username %s... Does anbody know what to do in this situation? Thanks, Alex
Try the ODBC connesction first. You can do it with the ilogin demo that come with informix drivers. Remember to update the services file adding : sqlexec 1525/tcp Try your connection with ms-access also. Alexander Schwinn <schwinn@informatik.uni-muenchen.de> wrote in message 39872056.EB3BEF3E@informatik.uni-muenchen.de... > Hi, > > I'm using an ODBC-Connection to an Informix Database in my ASP's. > (Informix CLI 2.5 32 Bit) When I'm trying to open a connection > (Conn.Open ...), the following error occurs: [ODBC... unable to load > locale categories). > I found an article in the Microsoft KB > (http://support.microsoft.com/support/kb/articles/Q166/4/41.ASP?LN=EN-US&SD= SO&FR=0). > > So I created the registry keys but now there is another error: > ...unknown Informix username %s... > > Does anbody know what to do in this situation? > > Thanks, > > Alex > > >
Alexander, Make sure that INFORMIXDIR is set (for example to C:\\INFORMIX) and $INFORMIX/bin is in your PATH. Of course, there are few environment variables / registry keys to play with (FM), but the above is mandatory for any client app. Sometimes (in case of mess) I-CLI/CSDK reinstallation might help. Best regards, Sergey Alexander Schwinn <schwinn@informatik.uni-muenchen.de> wrote in message news:39872056.EB3BEF3E@informatik.uni-muenchen.de... > Hi, > > I'm using an ODBC-Connection to an Informix Database in my ASP's. > (Informix CLI 2.5 32 Bit) When I'm trying to open a connection > (Conn.Open ...), the following error occurs: [ODBC... unable to load > locale categories). > I found an article in the Microsoft KB > (http://support.microsoft.com/support/kb/articles/Q166/4/41.ASP?LN=EN-US&SD= SO&FR=0). > > So I created the registry keys but now there is another error: > ...unknown Informix username %s... > > Does anbody know what to do in this situation? > > Thanks, > > Alex > > >
The ODBC Connection works with Access and Visual Interdev. It seems to me that the Username of the IIS (HOST_IWAM) is the Problem. Alex mp wrote: > Try the ODBC connesction first. > You can do it with the ilogin demo that come with informix drivers. > > Remember to update the services file adding : > sqlexec 1525/tcp > > Try your connection with ms-access also. > > Alexander Schwinn <schwinn@informatik.uni-muenchen.de> wrote in message > 39872056.EB3BEF3E@informatik.uni-muenchen.de... > > Hi, > > > > I'm using an ODBC-Connection to an Informix Database in my ASP's. > > (Informix CLI 2.5 32 Bit) When I'm trying to open a connection > > (Conn.Open ...), the following error occurs: [ODBC... unable to load > > locale categories). > > I found an article in the Microsoft KB > > > (http://support.microsoft.com/support/kb/articles/Q166/4/41.ASP?LN=EN-US&SD= > SO&FR=0). > > > > So I created the registry keys but now there is another error: > > ...unknown Informix username %s... > > > > Does anbody know what to do in this situation? > > > > Thanks, > > > > Alex > > > > > >