ADO causes run-time error 
Author Message
 ADO causes run-time error


I have a VB6 application installed on a Window 2000 machine with MDAC 2.6
SP2. On this machine I get the following error:

Run-time error '-2147467259 (800040005)
Automation error
Unspecified error

Other ADO code is executed successfully before the code that generates this
error is executed. As far as I can see the difference between the code that
works, and the function that generates the error is that the latter sets the
CursorType and CursorLocation properies on the recordset:

    Set rsRecordset = New adodb.Recordset
    rsRecordset.ActiveConnection = sConnectionString
    rsRecordset.CursorType = adOpenKeyset
    rsRecordset.CursorLocation = adUseClient
    rsRecordset.Open "SELECT * FROM MyTable"

On another Windows 2000 machine with MDAC 2.6 SP1 everything works!
Is this a known bug in SP2 or has the problem nothing to do with the two

Thanks in advance

Tue, 15 Nov 2005 18:32:11 GMT
 [ 1 post ] 

 Relevant Pages 

1. Filter of ADO Recordset causing run-time error 3265

2. loading more than 1 crystal report cause a run time error

3. Trapping SQL error in VB before ADO raises run-time error

4. Microsoft Visual C++ Run time library Run time error R6025

5. Microsoft Visual C++ Run time library Run time error R6025

6. ADO connection to Oracle run-time error ?

7. ado run-time error

8. ado sorting run-time error....

9. ADO Run time error #430 (when creating a recordset object)

10. ADO Run-time error...

11. ADO Run time error ( i think)

Powered by phpBB® Forum Software