Solved

ODBC Connection to MYSQL "Request returned with SQL_Error"

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How do i connect MySQL on Visual Studio 3 56
PHP loop not working 4 55
[MYSQL]: Delete is very slow 4 54
Excel - SQL export question 3 0
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Creating and Managing Databases with phpMyAdmin in cPanel.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

895 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

21 Experts available now in Live!

Get 1:1 Help Now