Connection Error 1

[logo]

I am trying to connect to a mySQL db via Visual Basic. However, I receive this error:

(TCX)(MyODBCTest)Host '(my server)' is not allowed to connect to this mySQL server

I can connect to the mySQL server just fine if I access it directly via the web.

Any ideas as to what could cause this error?

 

[Broccoli2]

Can you explain what you mean by 'directly via the web'? If you mean using something like ASP or PHP, this is likely to be running on the same server as your database, so the database connection is actually being made to and from the same machine (before the script output is sent to the client by the web server). However, a visual basic app running on a client will require a connection between two machines - which means MySQL will assess priveleges differently.

You can test the database connection from client to server directly using the

mysql

console that ships with the main MySQL distribution. If you get the same error there, then it's a question of manipulating the privelege tables in the

mysql

database. If you don't get an error there, then there's a bug in your vb or ODBC setup.

Hope this helps
-Rob

 

[logo]

Thanks....I am new to mySQL and am trying to create a connection using ADO. I'm sure that I am entering all of the connection info correctly, but I keep receiving the error I mentioned above.

Do you know of any good mySQL resources that you could point me to.

Thanks.
-Bill