I was unable to get 3.51.17 to work with MS Access 2002. I installed it from the msi bundle. The connector passes a test when creating or configuring a System DSN, but when I try to link tables from MS Access I get an error message:
[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-standard]Access denied for user 'readonly'@'%' to database 'mysql' (#1044) The same user with the same password has no trouble accessing the appropriate database ('giiexpr_db') using the mysql CLI from the same computer. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: Jim Winstead [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 17, 2007 5:25 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: MySQL Connector/ODBC 3.51.17 is available! > > Dear MySQL users, > > MySQL Connector/ODBC 3.51.17, a new version of the ODBC driver for the > MySQL database system, has been released. This release is the latest > release of the 3.51 series and is suitable for use with any MySQL > version including MySQL 4.1, 5.0, or 5.1. > > WARNING > > While we consider this a production release, we recommend caution in > upgrading due to changes in our build procedures, and the > large number > of bug fixes that have gone into the most recent releases. > > The release is now available in source and binary form for a number of > platforms from our download pages at > > http://dev.mysql.com/downloads/connector/odbc/3.51.html > > and mirror sites. Note that not all mirror sites may be up to > date at this > point in time, so if you can't find this version on some > mirror, please try > again later or choose another download site. > > We welcome and appreciate your feedback, bug reports, bug > fixes, patches, etc.: > > http://forge.mysql.com/wiki/Contributing > > Platform notes: > * There are no binary packages for Microsoft Windows x64 Edition. > * The Mac OS X binary packages are only provided as tarballs, > there is no > installer. > * There is no binary package for Mac OS X on 64-bit PowerPC > because Apple > does not currently provide a 64-bit PowerPC version of iODBC. > * The HP-UX 11.23 IA64 binary package does not include the > GUI bits because > of problems building Qt on that platform. > * The binary packages for Sun Solaris are only provided as > tarballs, not > the PKG format. > > Changes since the last release: > > Functionality added or changed: > * The setup library has been split into its own RPM > package, to allow > installing the driver itself with no GUI dependencies. > * Added an option (CHARSET) for specifying the default character > set for a connection. This must be used instead of a "SET NAMES" > statement. Also available from the GUI setup dialog. (Related > to Bug #6667 and Bug #9498.) > * Dis-allow NULL ptr for null indicator when calling SQLGetData() > if value is null. Now returns SQL_ERROR w/state 22002. > * Fixed calling convention ptr and wrong free in myodbc3i, and fixed > the null terminating (was only one, not two) when writing > DSN to string. > > Bugs fixed: > * myodbc3i did not correctly format driver info, which > could cause the > installation to fail. (Bug #29709) > * Multiple result sets were not correctly flushed when a statement > handle was closed. (Bug #16817) > * SQLProcedures() did not handle NULL parameters, which > could lead to > crashes (Bug #28316) > * SQLColumns() did not handle many of its parameters > correctly, which > could lead to incorrect results. The table name argument > was not handled > as a pattern value, and most arguments were not escaped > correctly when > they contained non-alphanumeric characters. (Bug #8860) > * If there was more than one unique key on a table, the > correct fields > were not used in handling SQLSetPos(). (Bug #10563) > * SQLColAttribute() returned the wrong value for > SQL_DESC_BASE_COLUMN_NAME > and SQL_DESC_BASE_TABLE_NAME for aliased fields. (Bug #6197) > * Calling SQLGetDiagField with RecNumber 0,DiagIdentifier > NOT 0 returns SQL_ERROR (Bug #16224) > * Correctly return error if SQLBindCol is called with an > invalid column > * Fixed error handling of OOM and bad connections in > catalog functions. > This might raise errors in code paths that had not seen > them in the past. > Gathered the logic for internal result sets into one > place. (Bug #26934) > * Fixed bad use of memory related to setup/util/GUI. (Bug #27315) > * Added a new DSN "OPTION" (FLAG_ZERO_DATE_TO_MIN) to > retrieve XXXX-00-00 > dates as the minimum allowed ODBC date (XXXX-01-01). Added another > option (FLAG_MIN_DATE_TO_ZERO) to mirror this but for > bound parameters. > FLAG_MIN_DATE_TO_ZERO only changes 0000-01-01 to > 0000-00-00. (Bug #13766) > * Fixed possible crash if SQLBindCol() was not called > before SQLSetPos(). > Fixed use of MYSQL structure pertaining to updating large blobs in > cursors. (Bug #10562) > > Enjoy! > > Jim Winstead > MySQL Inc. > > -- > MySQL ODBC Mailing List > For list archives: http://lists.mysql.com/myodbc > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]