• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 310
  • Last Modified:

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


0
gmanpert
Asked:
gmanpert
  • 3
1 Solution
 
bootrebootCommented:
Is the user's personal firewall enabled?  
0
 
gmanpertAuthor Commented:
I will have to check... and they are out of the office for the rest of the afternoon.
0
 
gmanpertAuthor Commented:
Firewall was not the problem.  Problem ended up being user gave me the wrong password.
0
 
gmanpertAuthor Commented:
Decent guess, but the problem ended up being back input from a user which led to the wrong question.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now