RTE -2147467259 (80004005)

[lifetotake]

I already knew about "AES.cls" and "RLE.cls" was already there. "clsServer.cls, clsSocket.cls, clsSockets.cls" didn't come with the package. I don't think I'm actually missing classes... because, when I take the simplest code... like below:

Code:

Public DB_Conn As ADODB.Connection
Public DB_RS As ADODB.Recordset
Private Sub Form_Load()
    'Create the database connection object
    Set DB_Conn = New ADODB.Connection
    Set DB_RS = New ADODB.Recordset
    
    DB_Conn.ConnectionString = "DRIVER={MySQL ODBC 5.1 Driver};SERVER=localhost;DATABASE=projectdungeon;PORT=3306;UID=root;PWD=;OPTION=3"
    DB_Conn.CursorLocation = adUseClient
    DB_Conn.Open
    
    DB_RS.Open "SELECT * FROM banned_ips WHERE 0=1", DB_Conn, adOpenStatic, adLockOptimistic
    DB_RS.Close
End Sub

I get


and debug highlighted this line:

Code:

DB_RS.Open "SELECT * FROM banned_ips WHERE 0=1", DB_Conn, adOpenStatic, adLockOptimistic

The database contained the tables and all. I doubt "clsServer.cls, clsSocket.cls, clsSockets.cls" will do anything to fix the problem cuz it seems I'm having it with anything that uses ADO.... or maybe just ODBC mysql connector. I've even got the same problem with vbgore when I got around to testing it.

Hook me up with "clsServer.cls, clsSocket.cls, clsSockets.cls" and I can just try adding them to see if I do happen to get any change.