MySQL Bugs: #17630: Access to multiple MySQL databases

Bug #17630	Access to multiple MySQL databases
Submitted:	21 Feb 2006 22:22	Modified:	28 Apr 2007 21:39
Reporter:	kirill kirill	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S2 (Serious)
Version:	3.51.8	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any
Tags:	ODBC5-RC

Description:
One can not set up access to multiple MySQL logical databases from MS Access. Whenever I tried to use second datasource, it is trying to use username/password of the first one.
Also MySQL driver makes Access really unstable on 64-bit windows.(After you managed to register the driver through the back door)

How to repeat:
Create 2 different MySQL logical databases with different user/passw, try to set up 2 datasources. Use the first one, then try the second one.

Suggested fix:
The obvious workaround is to use the same users/permissions on both databases

Thank you for a problem report. Please, specify the exact version of Connector/ODBC used. 3.51.12 (32-bit) works OK for me on XP 64-bit edition, by the way.

Thank you for the feedback.
Exact version: myodbc3.dll says that it's version is 3.51.8.0

I was unable to reproduce this problem WRT multiple Access databases, yet I can confirm the 64bit part of the problem.

Both 3.51.14 and 5.0 (2007-03-22) work as expected with:
 - MySQL 5.0.38BK on WinXP Pro SP2 localhost (32 bit)
 - MS Access 2003

Thank you for your bug report. This issue has already been fixed in the latest released version of that product, which you can download at

  http://www.mysql.com/downloads/

Hi. I've done some testing and here's what I've found:
 - MySQL 5.0.38Enterprise on WinXPx64 AMD
 - MS Office 2003 SP2 KB887616
 - MyODBC 3.51.14GA, connector/ODBC 5.0.11-beta

 - Create 2 databases, db1 and db2. Create two users, each with rights only to one of db's. User "db1" has privileges over "db1" database. User "db2" has privileges over "db2" database. Both users have different password.
 - Create some tables in both db1 and db2 databases
 - Create separate Machine DSN for each user/database and both connectors.
 - Launch Access, Import tables via ODBC Machine DSN for each DSN created in previous step.

Everything works fine. No "instability" noticed.