ODBC connection problem from Access to MySQL
Posted on 2009-05-11
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
Add -> (select MySQL 3.51 or 5.1 Driver)
Then fill in:
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?