Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Provider error when trying to get data in PowerPivot Expand / Collapse
Author
Message
Posted Thursday, October 4, 2012 12:48 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, May 10, 2013 3:22 PM
Points: 10, Visits: 144
I am using:
* Windows 7
* Microsoft Office Professional Plus 2010, v14.0.6112 (32-bit)
* MS SQL Server 2012 PowerPivot for Excel 32-bit, v 11.0.2100.60
* MySQL Connector/ODBC 5.2

I can create an ODBC connection to MySQL with no problems. And I can even use this ODBC connection from the Data tab in Excel (not PowerPivot) to get data from Other Source, either by pulling a single table from MySQL database or editing the connection properties/definition to provide a query (command text) that joins multiple tables.

However, in PowerPivot...
1) If I try to get data from a SQL Server connection, I get an error:
Cannot connect to the data source because the SqlServer provider is not installed
2) If try to get data from a text file, I get an error:
Details: Failed to connect to the server.
Reason: Provider information is missing from the connection string
3) If I try to create a connection From Other Source/ODBC, I get an error:
ERROR [HY010] [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.25a-27.1-log] or
Catastrophic failure. A connection could not be made.
**When I click for the dropdown list of databases in the Data Link Properties, the connection is made and list is shown.

On a different machine with the same versions of Office and PowerPivot and MySQL ODBC 5.1 instead of 5.2, I am able to get PowerPivot to work just fine. Note that in both the ODBC connection and Data Link in PowerPivot, the Initial Catalog must be left blank for the MySQL data pull to work. Not sure what is different on that machine to enable PowerPivot to work.

Any advice appreciated!
-Katherine
@sqlsassy
Post #1368643
Posted Saturday, November 3, 2012 2:15 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:17 AM
Points: 1,170, Visits: 1,209
Katherine,

Did you ever find a solution for this?

I'm in a similar position. I wanted to test a few things in PowerPivot (Using Office 2010 32-bit) -- everything works like a champ when connecting to SQL Server.

Then I tried to connect to MySQL db (Using MySQL Connector 5.2/ODBC 5.2). I can create the DSN fine. I can use this DSN to pull data from the MySQL db into Excel or MS Access just fine. But when I try to import data in the PowerPivot window, I can select my DSN, test the connection (tests fine), write a MySQL SELECT. The SELECT validates; I can go to the design window and execute the SELECT which brings back the correct records from MySQL. But when I click the Finish button I get the ERROR [HY010] [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.12] error.

I can work around this and export the MySQL data to somewhere else, but it would be nice if this worked correctly. Any one have any ideas?

Thanks,
Rob
Post #1380743
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse