• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 821
  • Last Modified:

Cant connect to remote database via MyODBC 3.51.20

Hi

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!
0
faiques
Asked:
faiques
  • 3
1 Solution
 
arrkerr1024Commented:
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.%).
0
 
faiquesAuthor Commented:
I've tried turning off the linux firewall (and the XP firewall) as well with no luck.  Any other thoughts?  Thanks!
0
 
faiquesAuthor Commented:
Need a solution quickly!
0
 
faiquesAuthor Commented:
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.  


0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now