Bug #37254 DSN-less connection prompting within application cannot lookup driver entry

Description:
When providing insufficient information on a DSN-less connection through an application such as Excel, the driver should prompt for the remaining information needed to connect. However, this fails with a message such as "Could not find driver 'MySQL ODBC 5.1 Driver' in system information.".

How to repeat:
In Excel:

Data -> Import External Data -> Import Data
New Source -> Other/Advanced -> Microsoft OLE DB Provider for ODBC Drivers
select "Use connection string", enter something such as "Driver={MySQL ODBC 5.1 Driver}"
Click OK, ("Test connection" tries to connect with SQL_DRIVER_NOPROMPT). Error will be displayed.

Suggested fix:
When using a DSN with insufficient information, prompting works fine, as the driver path (not name) is given. We need to make a distinction between the DSN-based and DSN-less connections when looking up the driver entry for prompting.

fix

Attachment: bug37254.diff (application/octet-stream, text), 6.25 KiB.

approved

Committed as rev 1133. Will be released in Connector/ODBC 5.1.5.

Additional fix to myodbc-installer committed in rev 1137.

Additional fixes for 64-bit Windows/WoW committed in rev 1139.

An entry was added to the 5.1.5 changelog:

The connector failed to prompt for additional information required to create a DSN-less connection from an application such as Microsoft Excel.