Description:
It is rather confusing when a user is attempting to provide a PW and DB name at connect time using a DSN which does not have those values already.
Although the driver behaves as expected and invokes the configuration app if the PW is needed, the DB combo box implies that you can select from a list of available databases. If you click that drop down however, you get a mysql error, "Loading database list not implemented for SQLDriverConnect()"
It is possible to manually enter a DB name, but the user might not know to do this after receiving an error. Also when you click inside the control for the first time, instead of it being empty, you find a single space present. If you were to start typing the DB name, it might look something like this which will fail, " test". Either the space needs to be removed or the value chopped.
How to repeat:
Steps to reproduce in Access:
Create a user DSN with values, DSNname, server-localhost, UID-root, PW,and DB should be left null
Create a new DB in Access, and select File/Get Ext Data / Link tables
Select ODBC from the type drop down, and choose the new DSN from the list of machine sources.
The MyODBC config app loads, enter the PW, and click the drop down for the DB name combo box (the error is received)
Manually type in the name of the MySQL database to connect to (notice the space)
If you confirm the dialog at this point a list of tables from the MySQL database specified should open, however due to bug #16640 Access crashes
Suggested fix:
I spoke with JimW about this, and we talked about a couple of potential fixes for this problem...
1. using a different method to retrieve the list of databases so that it works when the drop down is activated
OR
2. providing better information to alert the user to the next steps to take
AND/OR
3. Using a combo box when it is appropriate and allowed, and a text box when if it is necessary to manually enter the DB name.
