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 ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]