Cant connect to remote database via MyODBC 3.51.20

Posted on 2007-10-04
Last Modified: 2013-12-16

I have MySQL ODBC 3.51.20 installed on a windows XP machine. I have a MYSQL database on a Linux server on the same network.  When I try to Test the connection while setting up the DSN I get the following Error Message - [MySQL][ODBC 3.51 Driver]Lost connection to MySQL server at 'reading initial communication packet', system error: 0

If I connect to a MYSQL database on the Win XP box it works fine.  

I have already updated the user with the % thing and I have tried to open port 3306 on the linux server which may be the issue.  My WinXP install is version 2002 (no SP installed as this im just doing a proof of concept)

Thanks in advance!
Question by:faiques
    LVL 14

    Accepted Solution

    Try just turning off the linux firewall completely.  What distribution of linux are you running?  If redhat/cent/fedora do /etc/init.d/iptables stop, similar on other distros.

    The "% thingie" is a wildcard.  Use carefully.  You'll want to restrict it down to a specific IP block if at all possible, but after you get it to work the way it is (ex: 192.168.0.%).

    Author Comment

    I've tried turning off the linux firewall (and the XP firewall) as well with no luck.  Any other thoughts?  Thanks!

    Author Comment

    Need a solution quickly!

    Author Comment

    It was a firewall issue. But not on Linux, but rather with my VMWare server. I was using VMWare for my Linux server and forgot to open the port on it.  


    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Suggested Solutions

    The purpose of this article is to demonstrate how we can use conditional statements using Python.
    It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
    Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
    Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

    730 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

    15 Experts available now in Live!

    Get 1:1 Help Now