Problem with setting up ODBC

[Pete Rauch]

Hello, I am wondering if anybody can help me with a specific problem I am having, or at least point me in the right direction for more self-education.

I am using Microsoft Access as a front-end to a MySQL database. My production version is MySQL 4.0.18 running on SUSE 9, with the client on Windows XP using MySQL ODBC Driver 3.51. This is working fine.

I'm having trouble setting up a new system: MySQL 5.0.18 running on SLES 10, with the client on Windows XP using MySQL ODBC 5.1 (I also tried 3.51).

The specific error I am currently getting with ODBC 5.1 is: "Connection Failed: [08S01][MySQL][ODBC 5.1 Driver] Lost connection to MySQL Server at 'reading initial communication packet', system error: 2"

I've followed the documentation for setting up the DSN in Windows, but I think the problem might be on the Linux side. Windows can ping the server and I've opened up remote MySQL access on the Linux firewall, but I wonder if I need to change one or more settings to allow access. The ODBC documentation for the front-end was good, but I haven't seen a nice tutorial for the back-end. Are there any out there?


-Pete