Solved

ODBC Connection to MYSQL "Request returned with SQL_Error"

Posted on 2014-02-19
3
2,215 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 42

Accepted Solution

by:
Rob Jurd, EE MVE earned 250 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 250 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Join & Write a Comment

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
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: …
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

758 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

20 Experts available now in Live!

Get 1:1 Help Now