asked on

ODBC connection problem from Access to MySQL

Experts,

I have successfully set up numerous ODBC connection for a user on their desktop computers so they can access our MySQL database through Access. The problem I am running into is this...

When I try to create a DNS for the user's laptop... something isn't right.

Control Panel -> Administrative Tools -> DataSources -> ODBC -> System DSN
Then,
Add -> (select MySQL 3.51 or 5.1 Driver)

Then fill in:
DataSourceName:
Description:
Server:
User:
Password:

Here is where the problem lies! When things are working, if I click on the Database ... I should get a list of the databases and tables available to this user. But, I do not! It is as if the User and Password are wrong. I've checked our MySQL settings for this user and they are as follows:

select host,user,password from mysql.users; Returns,
'%' , 'myuser', 'mypassword'

Our MySQL installation allows 150 concurrent_connections but we only hae 26 open at present.

What am I overlooking here?

Thanks.

G

ASKER CERTIFIED SOLUTION

bootreboot

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

gmanpert

ASKER

I will have to check... and they are out of the office for the rest of the afternoon.

gmanpert

ASKER

Firewall was not the problem. Problem ended up being user gave me the wrong password.

gmanpert

ASKER

Decent guess, but the problem ended up being back input from a user which led to the wrong question.