Hmm... I tried this again with a user that has full access to all databases on the host, and it worked. This read-only user worked on the previous version of the connector, but it only worked on 3.51.17 when I gave it SELECT privilege on the mysql database.
Problem solved. 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: Jerry Schwartz [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 18, 2007 10:08 AM > To: 'Jim Winstead' > Cc: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: MySQL Connector/ODBC 3.51.17 fails to work with MS > Access 2002 > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]