SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Provider error when trying to get data in PowerPivot


Provider error when trying to get data in PowerPivot

Author
Message
Katherine Fraser
Katherine Fraser
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 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
Rob Taylor
Rob Taylor
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3904 Visits: 1616
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search