Solved

ODBC connection problem from Access to MySQL

Posted on 2009-05-11
4
275 Views
Last Modified: 2012-06-21
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
Comment
Question by:gmanpert
  • 3
4 Comments
 
LVL 2

Accepted Solution

by:
bootreboot earned 500 total points
ID: 24357392
Is the user's personal firewall enabled?  
0
 

Author Comment

by:gmanpert
ID: 24357498
I will have to check... and they are out of the office for the rest of the afternoon.
0
 

Author Comment

by:gmanpert
ID: 24435458
Firewall was not the problem.  Problem ended up being user gave me the wrong password.
0
 

Author Closing Comment

by:gmanpert
ID: 31580255
Decent guess, but the problem ended up being back input from a user which led to the wrong question.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question