Re: mysql odbc driver

I've been unable to get Access 2000 on Windows 98 to successfully use the MySQL ODBC (2.50.31) to link tables with MySQL on Linux. Same ODBC drivers work fine with earlier version of Access. However, I heard only today from a colleague who had similar problems that the latest update from Microsoft for the jet engine for 2000 now seems to make things work from Access 2000. I don't have any more detail than that. My earlier experience was that Access 2000 could connect to MySQL server ok, but if you tried to export a table from Access to MySQL using ODBC that the MySQL server log showed Access failed to generate fieldnames in its table create command, so you'd end up with a MySQL log entry like ... CREATE TABLE ( middleint, varchar(40), varchar(2), varchar(50), varchar(150), varchar(8), varchar(1), varchar(12), varchar(15), varchar(4)) ... which clearly MySQL rejected. Updating a table wasn't that reliable either. I did post questions about this at the time the the mysql list but got no fixes suggested, so I tend to think it was probably a MS problem. The MS lists also seemed to show that Access 2000 had problems using ODBC to talk to Oracle as well, so I don't think it was just a MySQL problem. If you do get it all working I'd really like to hear how you did it. Regards Nick Talbott IT Policy and Strategy Manager, Powys County Council, UK email nickt@powys.gov.uk FAX +44 (0) 1597 824781 web http://www.powys.gov.uk and http://www.powysweb.co.uk -----Original Message----- From: Lars Wilhelmsen <lw@ez.no> To: php-general@lists.php.net <php-general@lists.php.net> Date: 05 August 2000 08:51 Subject: RE: [PHP] mysql odbc driver >I've done it - no fuzz at all - just install it - and >set up your db's in the ODBC setup in Windows Control Panel. > >-- >Lars Wilhelmsen <lw@ez.no>, developer @ eZ systems <www.ez.no> > >-----Original Message----- >From: Curtis Cole [mailto:ccole@zebra.net] >Sent: 4. august 2000 23:43 >To: php-general@lists.php.net >Subject: [PHP] mysql odbc driver > > >has any had any luck using the mysql odbc driver for windows. >i want to use it to link my tables to access 2000. >I also can not get is to work. > >Curtis > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net >For additional commands, e-mail: php-general-help@lists.php.net >To contact the list administrators, e-mail: php-list-admin@lists.php.net > >