Solved

ODBC connection failing

Posted on 2013-05-16
5
291 Views
Last Modified: 2013-05-20
My ODBC was working perfectly and has now just stopped.

I have checked the MySQL Connector ODBC and the configuration settings are correct.

What else can I check?
0
Comment
Question by:Brogrim
[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
  • 2
  • 2
5 Comments
 
LVL 110

Expert Comment

by:Ray Paseur
ID: 39171602
Does your script test for error conditions and visualize those?
0
 

Author Comment

by:Brogrim
ID: 39171681
I dis'nt script it, I used the  "MySQL Connector ODBC Data Source Configuration
0
 
LVL 25

Accepted Solution

by:
Tomas Helgi Johannsson earned 500 total points
ID: 39180918
Hi!

Are you able to connect to the database using the ODBC test connection ?
If not check if there is any firewall blocking the port.
Is the database accessible locally where the it is hosted ?
Is your database user that you use to connect to the database allowed to connect from that particular IP address or any IP address ?
http://dev.mysql.com/doc/refman/5.6/en/adding-users.html

Regards,
    Tomas Helgi
0
 

Author Closing Comment

by:Brogrim
ID: 39181092
thanks
0
 
LVL 25

Expert Comment

by:Tomas Helgi Johannsson
ID: 39181321
Please see the grading guidelines here:
http://support.experts-exchange.com/customer/portal/articles/481419
A should be the default grade awarded unless the answer is deficient.
When closing the question, the asker should explain why a B grade was awarded.
So what was wrong with the answer?
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone 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

Title # Comments Views Activity
MYSQL responding very slow 3 68
check mysql insert 12 53
Error in sql query statment. 21 70
CMD R or Page Refresh Resending Update Query Data from Form 8 48
As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
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…

710 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