MySQL returned error: "Class not registered"

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Alright.... I'mma just slap up the data...
Screen shot of the error message:
http://img380.imageshack.us/img380/664/70877985qg0.jpg
Log file "CodeTracker.log"

Quote:

Call Var_Get(C:\Documents and Settings\Gamma\Desktop\vbGORE\ServerData\Server.ini,MYSQL,User)
Rtrn Var_Get = root
Call Var_Get(C:\Documents and Settings\Gamma\Desktop\vbGORE\ServerData\Server.ini,MYSQL,Password)
Rtrn Var_Get =
Call Var_Get(C:\Documents and Settings\Gamma\Desktop\vbGORE\ServerData\Server.ini,MYSQL,Database)
Rtrn Var_Get = vbgore
Call Var_Get(C:\Documents and Settings\Gamma\Desktop\vbGORE\ServerData\Server.ini,MYSQL,Host)
Rtrn Var_Get = 127.0.0.1
Call Var_Get(C:\Documents and Settings\Gamma\Desktop\vbGORE\ServerData\Server.ini,MYSQL,Port)
Rtrn Var_Get = 3306
Call Server_Unload()

and serverfps.txt is empty.

When I ran the server through vb6 to try to catch what like caused it... nothing... I have never had any problems connecting to mysql database before. The version of mysql is correct and all. I can connect to it with SQLyog, so.... I dunno... maybe someone can help me here. =/ I can't even get the stuff started to start learning the code's anatomy T_T

Psychoboy · **Posted:** Sat May 10, 2008 9:46 pm

is the username and password correct? Also did you setup the vbgore database and import the SQL?

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Psychoboy wrote:

is the username and password correct? Also did you setup the vbgore database and import the SQL?

I've checked the setting thoroughly. The character set is latin1, the username is correct, the password is correct, (I even made multiple dummy accounts to make sure it wasn't just the fact that I used root user without a password), I've changed 127.0.0.1 to localhost to make sure that wasn't the problem, the database has been fully imported and the setting has been adjusted for it too.

It's not a problem of "if the server is connecting to mysql", it's certainly connecting. It's a matter of the error being returned. I assume MySQL is returning the error, but it might be VB. I'm too amateur to know what is exactly returning the error. =/

Psychoboy · **Posted:** Sat May 10, 2008 10:28 pm

Which ODBC did you installed 5 or 3.51?

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Psychoboy wrote:

Which ODBC did you installed 5 or 3.51?

I have mySQL Connector/ODBC 3.51 installed.

Psychoboy · **Posted:** Sat May 10, 2008 10:36 pm

try putting a break point in MySQL_Init() at the beginning and just step through it and see what line it actually errors on. (it should jump straight to the error handling code after the line fails)

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Psychoboy wrote:

try putting a break point in MySQL_Init() at the beginning and just step through it and see what line it actually errors on. (it should jump straight to the error handling code after the line fails)

it went from

Code:

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

to

Code:

DB_Conn.Errors.Refresh

which just goes to giving you the "unknown error" message that also tells you what MySQL said the error is.... which is "Class not registered"

=/ I assess it has something to do with that query.... that query actually does look kinda odd..... All of the SQL queries look screwy.... what's with "0="? Shouldn't it just be "SELECT * FROM banned_ips"?!

Psychoboy · **Posted:** Sat May 10, 2008 10:49 pm

The query is fine.

Connect to the DB via SQLog and make sure the banned_ips table exists.

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Psychoboy wrote:

The query is fine.

Connect to the DB via SQLog and make sure the banned_ips table exists.

Yeah, the tables all exist.

Psychoboy · **Posted:** Sat May 10, 2008 10:56 pm

theres your problem... you said your database settings were correct...
in the server.ini cahnge the database setting to projectdungeon

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Psychoboy wrote:

theres your problem... you said your database settings were correct...
in the server.ini cahnge the database setting to projectdungeon

I noted that, that setting is propper.... x_X..........................

Settings.ini

Code:

Database=projectdungeon

Psychoboy · **Posted:** Sat May 10, 2008 11:01 pm

GamerSaga wrote:

Psychoboy wrote:

theres your problem... you said your database settings were correct...
in the server.ini cahnge the database setting to projectdungeon

I noted that, that setting is propper.... x_X..........................

Settings.ini

Code:

Database=projectdungeon

but the log you posted did not say that. You sure you changed the setting at the correct location? or was that log from before that change?

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Psychoboy wrote:

GamerSaga wrote:

Psychoboy wrote:

theres your problem... you said your database settings were correct...
in the server.ini cahnge the database setting to projectdungeon

I noted that, that setting is propper.... x_X..........................

Settings.ini

Code:

Database=projectdungeon

but the log you posted did not say that. You sure you changed the setting at the correct location? or was that log from before that change?

Yeah, I renamed the database and edited that setting since I made that post. I've edited many variables since I made my initial post xD.

Psychoboy · **Posted:** Sat May 10, 2008 11:04 pm

message me on an IM be easier this way we dont fill this thread up with this going back and forth and once ya got a solution post it =P

GamerSaga · **Joined:** Sat May 10, 2008 9:10 pm **Posts:** 8

Well, after sitting down for a while and trying multiple things, we didn't come up with any solution. Last thing I tried was reinstalling 'mysql-connector-odbc-3.51.25-win32.msi' and it didn't help the situation.

We did find out that DB_Conn returns "Undefined error" when

Code:

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

is ran. =/

vbGore Free Online RPG Engine

MySQL returned error: "Class not registered"