MySQL Bugs: #15786: Database selection errors

Bug #15786	Database selection errors
Submitted:	15 Dec 2005 18:44	Modified:	6 Dec 2006 5:33
Reporter:	Yuriy Pavlyutkin	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S3 (Non-critical)
Version:	5.0.0 Alpha	OS:	Windows (Windows 2000 SP4)
Assigned to:		CPU Architecture:	Any
Tags:	ODBC5-RC

Description:
Addition to Bug #12342:

Connector/ODBC Window => Database selection field:
1.  List of abracadabra instead database list (bug #12342). But if right database name is typed by hands, connection test is successful. 

2.  If typed database name consists of any single char (no database exists with such name), connection is successful. 

3. Connector/ODBC Window is called from MS Access. Right authentication data (host, user, password, port) is input. On database selection Connector/ODBC error message popup: Loading database list not implemented for SQLDriverConnect()

How to repeat:
See description

I have one solution for the problem using the database with MS Access. 

I've seen the problem when first using a database that is on a server and not on a localhost. Afterwards on the same computer, when I made a new DSN connection that uses the localhost, there was the problem when I opened the MS Access database. The solution was to create an empty database, save it with the same name as the earlier one, and then copying everything from the old database, into the new database. I saved the new file and deleted the old one. In the same folder I added the odbc_connector file with the new information that uses the localhost and everything works ok.

I hope that this solution will help someone that encourters the same problem with MS Access.

Best regards,
Robert Mileski

Access works now and we don't have a DB list on the config GUI anymore (for now).