Solved

ODBC connection problem from Access to MySQL

Posted on 2009-05-11
4
286 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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Familiarize people with the process of utilizing SQL Server views 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 Access…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

691 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