Oninit cdi / Archive
Talk to an expert →

Help on Intersolv Odbc driver for Informix

Posted in 1999

Topics: Connectivity: ODBC / JDBC / .NET, Internationalization & Character Sets

Gennaro Napolitano — — source: Informix-list mailing list archive (1991-1998)

Hi all I have a little problem using the Intersolv Odbc driver V3.01 32-BIT INFORMIX. I need to use it inside a perl script. I have a little Perl script executing just a connect to the server(Informix Dynamic Server 7.30 on IRIX); if I run this script from a DOS shell(Windows NT 4.0 SP4 with Web Server (Microsoft IIS) ) it works fine, but if I try to call it using the browser(Netscape 4.6) I receive the following error message(Odbc trace): test fb:f5 ENTER SQLAllocEnv HENV * 0x00f4900c test fb:f5 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x00f4900c ( 0x01381440) test fb:f5 ENTER SQLAllocConnect HENV 0x01381440 HDBC * 0x014b1930 test fb:f5 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV 0x01381440 HDBC * 0x014b1930 ( 0x013814e8) test fb:f5 ENTER SQLDriverConnectW HDBC 0x013814e8 HWND 0x00000000 WCHAR * 0x6a9ac284 [ -3] "******\\ 0" SWORD -3 WCHAR * 0x6a9ac284 SWORD 8 SWORD * 0x00000000 UWORD 0 <SQL_DRIVER_NOPROMPT> test fb:f5 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR) HDBC 0x013814e8 HWND 0x00000000 WCHAR * 0x6a9ac284 [ -3] "******\\ 0" SWORD -3 WCHAR * 0x6a9ac284 SWORD 8 SWORD * 0x00000000 UWORD 0 <SQL_DRIVER_NOPROMPT> DIAG [S1000] [INTERSOLV][ODBC Informix driver][Informix]Unable to load locale categories. (-406) test fb:f5 ENTER SQLErrorW HENV 0x01381440 HDBC 0x013814e8 HSTMT 0x00000000 WCHAR * 0x0012f5fc (NYI) SDWORD * 0x014b1924 WCHAR * 0x0012f1fc SWORD 512 SWORD * 0x0012f634 test fb:f5 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV 0x01381440 HDBC 0x013814e8 HSTMT 0x00000000 WCHAR * 0x0012f5fc (NYI) SDWORD * 0x014b1924 (-406) WCHAR * 0x0012f1fc [ 76] "[INTERSOLV][ODBC Informix driver][Info" SWORD 512 SWORD * 0x0012f634 (76) test fb:f5 ENTER SQLFreeConnect HDBC 0x013814e8 test fb:f5 EXIT SQLFreeConnect with return code 0 (SQL_SUCCESS) HDBC 0x013814e8 Thanxs a lot in advance Ciao Gennaro

↪ replying to Gennaro Napolitano
schatzy@my-deja.com — — source: Informix-list mailing list archive (1991-1998)

Hi, This most likely means you'll need to set the INFORMIXSERVER / INFORMIXDIR environment variables in your Perl script somehow. I don't know how the IIS connection is setting them properly - perhaps the Intersolv driver sees them in the Windows environment when you go this route. I suggest a multi-tier ODBC solution that would allow you to store these environment variables on the server side where they belong. Openlink ODBC (www.openlinksw.com) will provide such a solution. Good luck, Stephen In article <38340B1D.7A9941A4@italdata.it>, Gennaro Napolitano <Gennaro.Napolitano@italdata.it> wrote: > Hi all > > I have a little problem using the Intersolv Odbc driver V3.01 32-BIT > INFORMIX. > > I need to use it inside a perl script. > > I have a little Perl script executing just a connect to the > server(Informix Dynamic Server 7.30 on IRIX); if I run this script from > a DOS shell(Windows NT 4.0 SP4 with Web Server (Microsoft IIS) ) it > works fine, but if I try to call it using the browser(Netscape 4.6) I > receive the following error message(Odbc trace): > > test fb:f5 ENTER SQLAllocEnv > HENV * 0x00f4900c > > test fb:f5 EXIT SQLAllocEnv with return code 0 > (SQL_SUCCESS) > HENV * 0x00f4900c ( 0x01381440) > > test fb:f5 ENTER SQLAllocConnect > HENV 0x01381440 > HDBC * 0x014b1930 > > test fb:f5 EXIT SQLAllocConnect with return code 0 > (SQL_SUCCESS) > HENV 0x01381440 > HDBC * 0x014b1930 ( 0x013814e8) > > test fb:f5 ENTER SQLDriverConnectW > HDBC 0x013814e8 > HWND 0x00000000 > WCHAR * 0x6a9ac284 [ -3] "******\\ 0" > SWORD -3 > WCHAR * 0x6a9ac284 > SWORD 8 > SWORD * 0x00000000 > UWORD 0 <SQL_DRIVER_NOPROMPT> > > test fb:f5 EXIT SQLDriverConnectW with return code -1 > (SQL_ERROR) > HDBC 0x013814e8 > HWND 0x00000000 > WCHAR * 0x6a9ac284 [ -3] "******\\ 0" > SWORD -3 > WCHAR * 0x6a9ac284 > SWORD 8 > SWORD * 0x00000000 > UWORD 0 <SQL_DRIVER_NOPROMPT> > > DIAG [S1000] [INTERSOLV][ODBC Informix driver][Informix]Unable to load > locale categories. (-406) > > test fb:f5 ENTER SQLErrorW > HENV 0x01381440 > HDBC 0x013814e8 > HSTMT 0x00000000 > WCHAR * 0x0012f5fc (NYI) > SDWORD * 0x014b1924 > WCHAR * 0x0012f1fc > SWORD 512 > SWORD * 0x0012f634 > > test fb:f5 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) > HENV 0x01381440 > HDBC 0x013814e8 > HSTMT 0x00000000 > WCHAR * 0x0012f5fc (NYI) > SDWORD * 0x014b1924 (-406) > WCHAR * 0x0012f1fc [ 76] "[INTERSOLV][ODBC Informix > driver][Info" > SWORD 512 > SWORD * 0x0012f634 (76) > > test fb:f5 ENTER SQLFreeConnect > HDBC 0x013814e8 > > test fb:f5 EXIT SQLFreeConnect with return code 0 > (SQL_SUCCESS) > HDBC 0x013814e8 > > Thanxs a lot in advance > > Ciao Gennaro > > Sent via Deja.com http://www.deja.com/ Before you buy.

Related threads