ODBC connection failing

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?
BrogrimInformation Systems Development ManagerAsked:
Who is Participating?
 
Tomas Helgi JohannssonCommented:
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
 
Ray PaseurCommented:
Does your script test for error conditions and visualize those?
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
I dis'nt script it, I used the  "MySQL Connector ODBC Data Source Configuration
0
 
BrogrimInformation Systems Development ManagerAuthor Commented:
thanks
0
 
Tomas Helgi JohannssonCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.