RTE -2147467259 (80004005)

[lifetotake]

Well, I was bored, and decided to make MirageSource server with MySQL work, but I hit a snag. I have ODBC 3.51 installed. I have MySQL 5.0.14 installed. I run WindowsXP (SP2).... I have every imaginable DLL and OCX file registered and I still get this error. I've searched google, and these forum, and no one has provided sufficient information that is useful. So I ask you all, how do I make this work?! I've tried everything I've found, to no avail.

RTE -2147467259 (80004005):
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

I debug and I get this highlighted:

Code:

Conn_Client.Open

When I put a watch on Conn_Client, it shows 0 errors.

Thanks, in advance.

[lifetotake]

Well, now I get a new error message...

(Same RTE) RTE -2147467259 (80004005):

Undefined error

Before I got this...

(Same RTE) RTE -2147467259 (80004005):

Class not registered.

btw, what is pre-population? I only know the basics about MySQL because I'm actually a php programmer. I only know about the basic querying of it.

[lifetotake]

Oh, the database is created, and has the SQL dump imported. Even with all this, I still get "Class not registered" =/. (on a side note, I get the same problem with vbgore...) It seems that all MySQL connections with ODBC 3.51 and 5.1 just give me "Class not registered".. I registered a lot of files and also installed SP5 and SP6.... still got the "Class not registered" error =/

[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.

[lifetotake]

In that check list:
Check First, you have MySQL 5.045 installed and running.
Check Second, you have the ODBC connector driver version 5.1.4 installed.
Check Third, you have properly declared your ADODB in your code
Check Fourth, your connection string uses DRIVER={MySQL ODBC 5.1 Driver} instead of DRIVER={MySQL ODBC 3.51 Driver}
Negative Does it work =/

I've looked thoroughly into this problem and it seems that I'm the only one with it. So it must just be something on my system causing it to not work properly, which I have no idea what could cause this. I'm just gunna give up with making VB6 work with MySQL. I pretty much just wanted to have a server function with MySQL, and I figure since I know I can do it with C++, I'll just move over to C++. I appreciate the attempt at helping me getting this fixed.

[lifetotake]

I still get the same error. "Class not registered", like in that screen shot image that I posted. It's gotta be something wrong with ADO or my computer.