• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 300
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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