Solved

ODBC connection failing

Posted on 2013-05-16
5
280 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 24

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 24

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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Loading csv or delimited data files to MySQL database is a very common task frequently questioned about and almost every time LOAD DATA INFILE comes to the rescue. Here we will try to understand some of the very common scenarios for loading data …
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 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

16 Experts available now in Live!

Get 1:1 Help Now