Solved

ODBC connection failing

Posted on 2013-05-16
5
281 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
  • 2
  • 2
5 Comments
 
LVL 108

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
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…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now