Solved

ODBC connection problem from Access to MySQL

Posted on 2009-05-11
4
282 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
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.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

734 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