Problems accessing Oracle
The following simple piece of VB6 code breaks at 'End' reporting error "The
instruction at '...' referenced memory at '...'. The memory could not be
'written'. Click OK to terminate the program":
Private Sub Command1_Click()
Dim SC As New ADODB.Connection
SC.Open "Provider=MSDASQL.1;Data Source=Boniteta32;Extended
Properties=""DSN=Boniteta32;UID=baza;PWD=sql;DBQ=abraxas"""
SC.CommandTimeout = 10
SC.Close
Set SC = Nothing
End
End Sub
Debugger reports this:
(14bc.122c): Access violation - code c0000005 (first chance)
First chance exceptions are reported before any exception handling.
This exception may be expected and handled.
eax=00371ff8 ebx=008f600c ecx=00000160 edx=ffffffff esi=008f3e9c edi=00000000
eip=77c2a573 esp=0012fb18 ebp=0012fb34 iopl=0 nv up ei pl nz na pe nc
cs=001b ss=0023 ds=0023 es=0023 fs=003b gs=0000 efl=00210206
*** ERROR: Symbol file could not be found. Defaulted to export symbols for
C:\W
INDOWS\system32\msvcrt.dll -
msvcrt!get_sbh_threshold+0x167:
77c2a573 895a04 mov dword ptr [edx+4],ebx
ds:0023:00000003=????????
. 0 Id: 1754.fec Suspend: 1 Teb: 7ffdd000 Unfrozen
*** ERROR: Symbol file could not be found. Defaulted to export symbols for ntdl
l.dll -
ChildEBP RetAddr Args to Child
WARNING: Stack unwind information not available. Following frames may be wrong.
0012fb34 77c2c25d 00371ea0 008f3ebc 0012fbbc msvcrt!get_sbh_threshold+0x167
*** ERROR: Symbol file could not be found. Defaulted to export symbols for D:\O
racle\product\10.1.0\Client_1\bin\oracore10.dll -
0012fb78 61127b40 008f3ea0 0012fbbc 00000000 msvcrt!free+0x42
0012fb8c 610e037b 008f3ea0 008f4df0 00000004 oracore10!ss_mem_fre+0x20
0012fba0 610f743f 008f3ea0 10000000 00000001 oracore10!lmlterm+0x3b
*** WARNING: Unable to verify checksum for D:\Oracle\product\10.1.0\Client_1\BIN
\OCI.dll
*** ERROR: Symbol file could not be found. Defaulted to export symbols for D:\O
racle\product\10.1.0\Client_1\BIN\OCI.dll -
0012fd5c 01c3739b 008f5590 0012fd74 1000a5fc oracore10!lpmterm+0xdf
*** WARNING: Unable to verify checksum for D:\Oracle\product\10.1.0\Client_1\BIN
\SQORA32.DLL
*** ERROR: Symbol file could not be found. Defaulted to export symbols for D:\O
racle\product\10.1.0\Client_1\BIN\SQORA32.DLL -
0012fd68 1000a5fc 008f5590 0012fd90 1000a27f OCI!lpmterm+0x1b
0012fd74 1000a27f 10000000 00000000 00000001 SQORA32!SQLTablesW+0xc7c
0012fd90 7c9011a7 10000000 00000000 00000001 SQORA32!SQLTablesW+0x8ff
0012fdb0 7c923f31 1000a210 10000000 00000000 ntdll!LdrInitializeThunk+0x29
*** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\W
INDOWS\system32\kernel32.dll -
0012fe34 7c81ca3e 00011970 6610e470 7ffde000 ntdll!LdrShutdownProcess+0x142
0012ff28 7c81cab6 00000000 77e8f3b0 ffffffff kernel32!IsValidLocale+0x8eb
*** ERROR: Symbol file could not be found. Defaulted to export symbols for C:\W
INDOWS\system32\MSVBVM60.DLL -
0012ff3c 6600362f 00000000 00011970 7c9118f1 kernel32!ExitProcess+0x14
*** ERROR: Module load completed but symbols could not be loaded for image004000
00
0012ffb8 0040116a 004012c8 7c816d4f 00011970 MSVBVM60!ThunRTMain+0xb3
0012fff0 00000000 00401160 00000000 78746341 image00400000+0x116a
My code is pretty simple and I AM SURE there is nothing wrong with it. It
simply opens a connection, sets command timeout and closes the connection.
What on earth could possibly be causing this "access violation" error???
Regards,Blaz