ODBC Connection to MYSQL "Request returned with SQL_Error"

Hi - I'm hoping someone can help me.

I am running a Windows 7 32 bit workstation and I am trying to establish an ODBC connection to a MySQL database running on a Linux box.

I am able to connect using a similar workstation and the same ODBC settings and driver, but on this PC I get the following error when I try to connect:

Request returned with SQL Error.

Any help would be greatly appreciated.

Thanks,
John
johnlschmidt2Asked:
Who is Participating?
 
RobConnect With a Mentor Owner (Aidellio)Commented:
First thing that comes to mind is a firewall issue. Can you disable the firewall on the Windows machine and try again?
0
 
AielloJConnect With a Mentor Commented:
johnlschmidt2,

Try turning off the firewall on the PC and see if that changes things.  Also, does the mySQL database allow access from all IP's, a single IP, or a range of IP's?  Same for usernames.

AielloJ
0
 
johnlschmidt2Author Commented:
Thanks for the suggestions. It turned out to be a network security issue on the server housing the SQL database.
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.