Hi Rowland, I've been hoping someone with MySQL experience would give you the answer you need; in the meantime, my memory is that there was a problem with some of the later MySQL drivers on the Windows side doing just what you describe-- working correctly in general (i.e., your hitting the test button), but not with Filemaker--, and the Filemaker Knowledge Base Article on the subject (watch for line wrap):
http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php? p_faqid=6510&p_created=1182295651&p_sid=XyRRnvij&p_accessibility=0&p_redirec t=&p_lva=&p_sp=cF9zcmNoPTEmcF9zb3J0X2J5PSZwX2dyaWRzb3J0PSZwX3Jvd19jbnQ9NCw0J nBfcHJvZHM9JnBfY2F0cz0mcF9wdj0mcF9jdj0mcF9wc19hbnNfdXBkYXRlZD0mcF9wYWdlPTEmc F9zZWFyY2hfdGV4dD1NeVNRTCBEcml2ZXI*&p_li=&p_topview=1 ... points to an earlier driver, 3.51.14, than what your error code seems to be saying you are using (5.1). Try installing the earlier driver and setting up your DSN pointing to it. http://dev.mysql.com/downloads/ John Weinshel Datagrace Vashon Island, WA (206) 463-1634 Member, FileMaker Business Alliance Certified For FileMaker 8 Certified For FileMaker 7 -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Rowland & Wilma Carson Sent: Sunday, November 09, 2008 3:43 PM To: [email protected] Subject: ODBC error question I'm trying to deploy on a Windows XP laptop a solution I know is working on my Mac. I'm using FMP as a user-friendly front-end to a MySQL database on a remote server. Everything works OK on the Mac (first on the localhost and then on the target server), and I checked for feasibility using a simple FMP file on the same Windows machine with the remote server before spending time developing this solution. I didn't think I'd changed any relevant settings on that laptop since then. I connect to the remote server using SSH tunneling (using PuTTY on the Windows system) because direct connexion of off-site tools is prohibited by the site where the server lives. However, when I now try to connect from the developed FMP file on the Windows XP machine to the MySQL database I'm getting an error message I've not seen before, and I'm at a loss to know what's causing it. "ODBC Error: [MySQL][ODBC 5.1 Driver]Can't connect to MySQL server on 'localhost' (10061)". I know the connexion from the Windows machine to the server is OK as I can use the GUI MySQL Admin tool from it. That seems to suggest that the problem must be in the ODBC driver. But when I configure the ODBC driver in Windows and hit the test button it comes back with OK. None of the relevant help systems seems to offer error numbers in the range of this one. Anyone got any ideas? I am working a bit in the dark here as I am basically a Mac person. regards Rowland -- | Wilma & Rowland Carson http://home.clara.net/rowil/ | <[EMAIL PROTECTED]> ... that's Rowland with a 'w' ...
