Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 303
  • Last Modified:

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?
0
Brogrim
Asked:
Brogrim
  • 2
  • 2
1 Solution
 
Ray PaseurCommented:
Does your script test for error conditions and visualize those?
0
 
BrogrimAuthor Commented:
I dis'nt script it, I used the  "MySQL Connector ODBC Data Source Configuration
0
 
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
 
BrogrimAuthor 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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