VB Forum / Database Access / July 2006

The following simple piece of 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=????????

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