Informix ODBC failing in IIS application
Posted in 2000
Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET, Migration, Import/Export & Data Conversion, Internationalization & Character Sets
When running IIS in multi-threading mode, the informix ODBC driver is causing a access violation and dying. Has anyone seen this? I would appreciate any suggestions to solve this... Thanks in advance, Neil Pengelly, Disus Inc. neil@disus.com Here are the details: (Note, the problem doesn't occur when IIS is put into debug mode (single-threaded), so this leads me to believe this is a problem related to threading in the ODBC driver). ***** Activity prior to crash ***** dule Load: C:\\PROGRAM FILES\\COMMON FILES\\SYSTEM\\OLE DB\\msdasqlr.dll (symbol loading deferred) Module Load: C:\\WINNT\\SYSTEM32\\mswstr10.dll (symbol loading deferred) Module Load: C:\\INFORMIX\\BIN\\iclit09b.dll (symbol loading deferred) Module Load: C:\\INFORMIX\\BIN\\iregt07b.dll (symbol loading deferred) Module Load: C:\\INFORMIX\\BIN\\irrgt09a.dll (symbol loading deferred) Module Load: C:\\INFORMIX\\BIN\\igl4n304.dll (symbol loading deferred) Module Load: C:\\INFORMIX\\BIN\\irclt09b.dll (symbol loading deferred) Module Load: C:\\WINNT\\SYSTEM32\\ctl3d32.dll (symbol loading deferred) Module Load: C:\\WINNT\\SYSTEM32\\odbccp32.dll (symbol loading deferred) Thread Create: Process=0, Thread=47 Module Load: C:\\INFORMIX\\BIN\\igo4n304.dll (symbol loading deferred) Module Unload: C:\\INFORMIX\\BIN\\igo4n304.dll Thread Create: Process=0, Thread=48 Thread Create: Process=0, Thread=49 Module Load: C:\\PROGRAM FILES\\COMMON FILES\\SYSTEM\\ADO\\msadrh15.dll (symbol loading deferred) Module Load: C:\\INFORMIX\\BIN\\igo4n304.dll (symbol loading deferred) Module Unload: C:\\INFORMIX\\BIN\\igo4n304.dll First chance exception c0000005 (Access Violation) occurred Thread stopped. Module Load: C:\\INFORMIX\\BIN\\iclit09b.dll (no symbols loaded) *********************************************************** * Exception Monitor Log Analyzer Report version 7.0.0.0 * Report Created from: C:\\Program Files\\Debuggers\\bin\\em\\logs\\EM_1316-163859-96-2000.dbl * Report Created on: September 06,2000 at 04:43 PM * The following fault type was detected: Access Violation * Exception Monitor 7.1.2195.5 * Log generated on: 9/6/2000 4:41:03 PM *********************************************************** WARNING: ReadLogs detected that a module being called was not loaded into memory. ReadLogs has attempted to identify this file from previous ModLoad commands. If the filename was resolved, the name will be preceeded with "NOT IN MEMORY". PLEASE NOTE this message is valid ONLY if the NOT IN MEMORY is in the TOP line of the stack trace.In order to understand what this could mean and how to further diagnose this, please read the product documentation. The service faulted in thread # 39 The stack for the faulting thread follows. Column 1 shows the Child EBP, Column 2 shows the Return Address, Column 3 shows the module called, and column 4 shows the resolved name if column 3 was not able to locate or use symbols. To read the stack, start at the bottom and work your way up. The function on the bottom called the function above it, which called the function above it, etc. 0000000000c4fa18 0000000000bc614e iclit09b!0x0000000070172F28 (No FPO) 0000000000000003 0000000000000000 0x0000000000BC614E (No FPO) NOT IN MEMORY: ***** The following is extended information from the log: 029bdbf8 : 00000176 029bdbfc : 029be2b4 029bdc00 : 701733f2 : C:\\informix\\bin\\iclit09b.dll+0x333f2 029bdc04 : 00c4fa18 029bdc08 : 00000176 029bdc0c : 701eacd8 : C:\\informix\\bin\\iclit09b.dll+0xaacd8 029bdc10 : 00c4fa18 029bdc14 : 000000bb 029bdc18 : 00000000 029bdc1c : 00000000 029bdc20 : 00c47bf8 029bdc24 : 03beffc8 029bdc28 : 00000000 029bdc2c : 00000000 029bdc30 : 00000000 029bdc34 : 00000000 029bdc38 : 00000000 029bdc3c : 00000000 029bdc40 : 00000000 029bdc44 : 00000000 029bdc48 : 00000000 029bdc4c : 00000000 029bdc50 : 00000000 029bdc54 : 00000000 029bdc58 : 00000000 029bdc5c : 00070000 029bdc60 : 00000000 029bdc64 : 03beffc8 029bdc68 : 00c47bf8 029bdc6c : 03beffc8 029bdc70 : 00230178 029bdc74 : 03beffc0 029bdc78 : 029bdd88 029bdc7c : 779c2cea : C:\\WINNT\\system32\\OLEAUT32.DLL+0x12cea 029bdc80 : 0000027f 029bdc84 : 0000027f 029bdc88 : 000a96c7 029bdc8c : 029be9a8 029bdc90 : 00000006 029bdc94 : 0000ea89 029bdc98 : 00000000 029bdc9c : 027f0e7f 029bdca0 : 029bdd88 029bdca4 : 779c2a46 : C:\\WINNT\\system32\\OLEAUT32.DLL+0x12a46 029bdca8 : 00000007 029bdcac : 00000000 029bdcb0 : 00000020 029bdcb4 : 779b149b : C:\\WINNT\\system32\\OLEAUT32.DLL+0x149b !inetdbg.ds 29bdcb8 to dump next block ***** The program found one or more files on the stack that did not have symbols loaded for it. The actual dll name(s) appear in the right-most column of the stack list. If this is a file you created, you can get symbolic information for it by compiling it as a debug file and EM will be able to read it. If this file is from another manufacturer or vendor, contact the vendor to get symbol files for the files in question.By getting the symbolic information, you can trouble shoot the problem even further by seeing which function calls were being used when the system crashed. NOTE: The function(s) that are unresolved may not be in the faulting thread, but you still want to obtain symbols for future debugs.***** The following third party modules were running in the process's memory space: C:\\Disus\\MyControl.dll MYCONTROL.DLL] Company Name: Test. Product Version: (1.0:0.16) File Version: (1.0:0.16) File Size (bytes): 155648 File Date: Wed Sep 06 16:35:26 2000 Module has NO symbols C:\\Disus\\VBWINS~1.DLL VBWINS~1.DLL] Company Name: Test Product Version: (1.0:0.0) File Version: (1.0:0.0) File Size (bytes): 23552 File Date: Mon Jan 18 07:01:16 1999 Module has NO symbols C:\\informix\\bin\\iclit09b.dll ICLIT09B.DLL] Company Name: Informix Software, Inc. File Description: Informix 32-Bit 3.00 ODBC Driver Product Version: (3.31:0.10287) File Version: (3.31:0.10287) File Size (bytes): 770048 File Date: Thu Aug 03 15:27:56 2000 Module has NO symbols C:\\informix\\bin\\iregt07b.dll IREGT07B.DLL] Company Name: Informix Software, Inc. File Description: INFORMIX-Connect Registry Handler Product Version: (2.40:0.10287) File Version: (2.40:0.10287) File Size (bytes): 53248 File Date: Tue Oct 19 15:12:38 1999 Module has NO symbols C:\\informix\\bin\\irrgt09a.dll IRRGT09A.DLL] Company Name: Informix Software, Inc. File Description: INFORMIX-Connect ixreg resource DLL Product Version: (2.40:0.10287) File Version: (2.40:0.10287) File Size (bytes): 32768 File Date: Tue Oct 19 15:12:38 1999 Module has NO symbols C:\\informix\\bin\\igl4n304.dll IGL4N304.DLL] Company Name: Informix Software, Inc. File Description: INFORMIX-GLS Library DLL Product Version: (3.1:0.3) File Version: (3.1:0.3) File Size (bytes): 206336 File Date: Fri Oct 15 14:32:38 1999 Module has NO symbols C:\\informix\\bin\\irclt