ODBC

[tofuboy]

Having problems with odbc... I want to use Ms Access as the front end for MySQL database. I've installed the correct driver (myodbc-2.50.19-NT) my OS is win 2000.This is what im entering into the TDX mysql default configuration

Windows DNS name: tofuboysDB
Server: (**what do I put here???**)
MySQL Database name: MDB
User: root (is this the user in mysql???)
password: ******* (is this the password in mysql???)
Port(if not 3606): (it is already set to 3606 by MySQL??)

error message that i get

ODBC--call failed
[TCX][MyODBC]Can't connect to MySQL server on (10049)(#2003)

please help

 

[aaahhhrrggghhhh]

Hi.

The answer depends on how you normally connect to mysql?

Try going through the ODBC Administration. Normally, the details about the name of your server go there, you should be able to get the name from your techie guys as this information is generally classified for most companies (to avoid hackers).

I would assume that you should ask your technical people for the name of the server that mysql is on, and put it in its correct place. The mysql ODBC drivers should work then.

Regards,
Mr Big. Dont be small. be BIG