Bug #69154 can't connect to MySql via ODBC in MS Excel 2010 PowerPivot
Submitted: 6 May 2013 13:31 Modified: 6 May 2013 15:04
Reporter: An R Email Updates:
Status: Closed Impact on me:
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.2w OS:Windows (vista 64bit)
Assigned to: CPU Architecture:Any
Tags: excel 2010

[6 May 2013 13:31] An R
When created a data link to connect to my MySql Server 5.x via ODBC using Excel 2010's Power Pivot, I get the error:

Test connection failed because of an error initializing provider. Specified driver could not be loaded due to system error 126 (MySql ODBC 5.2w Driver)

How to repeat:
1) install odbc 64 bit for windows
2) create odbc user DSN
3) open excel 2010 with PowerPivot plugin
4) use 'obtain data from external data source'
5) choose 'others (ODBC)'
6) click "Build..."
7) choose DSN created in (2)
8) input user/password
9) hit Test Connection

Suggested fix:
[6 May 2013 15:04] An R
issue was fix by installing both 32bit and 64bit drivers