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

x
?
Solved

ODBC Connection to MYSQL "Request returned with SQL_Error"

Posted on 2014-02-19
3
Medium Priority
?
3,017 Views
Last Modified: 2014-03-06
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
0
Comment
Question by:johnlschmidt2
3 Comments
 
LVL 43

Accepted Solution

by:
Rob earned 750 total points
ID: 39872844
First thing that comes to mind is a firewall issue. Can you disable the firewall on the Windows machine and try again?
0
 
LVL 13

Assisted Solution

by:AielloJ
AielloJ earned 750 total points
ID: 39892114
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
 

Author Comment

by:johnlschmidt2
ID: 39910411
Thanks for the suggestions. It turned out to be a network security issue on the server housing the SQL database.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

885 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