Bug #70017 MySQL ODBC connection (PowerPivot)
Submitted: 13 Aug 2013 17:55 Modified: 17 Oct 2013 9:31
Reporter: Nikola Mijic Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:5.5.27 OS:Windows (Windows 7 - 64 bit)
Assigned to: Bogdan Degtyariov CPU Architecture:Any

[13 Aug 2013 17:55] Nikola Mijic 
Description:
I'm trying to import data from MySQL to Microsoft Excel (PowerPivot).  However when I try to run a query I get the following error: 

- ERROR [HY010] [MySQL][ODBC 5.2(a) Driver][mysqld-5.5.27]

when I validate the query and DB connection, both are successful.  I'm not sure why I am getting this error when I execute the SQL statement. 

I'm running windows 7- 64 bit operating system and am using Excel 2010. I downloaded the 64-bit ODBC driver (http://dev.mysql.com/downloads/mirror.php?id=411736). 

How to repeat:
- download driver 
- create an OLEDB/ODBC connection 
- when selecting how to import the data: "Write a query that will specify the data to import
- run the query
[16 Aug 2013 9:50] Bogdan Degtyariov 
Hi Nikola,

Thank you for your interest in MySQL software.
Unfortunately, I do not have all necessary details to proceed with the bug verification.
Can you please provide the following details:

 1. What is the version of MS Excel you are using?

 2. The description how to repeat the problem is not clear.
    Please give the step-by-step instructions, such as following
      
      - start Excel
      - click "Data" tab
      - click "From Other Sources" -> "From Microsoft Query"
      - choose the Data Source in the list
      .....
     
Thanks.
[17 Sep 2013 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[17 Sep 2013 9:31] Bogdan Degtyariov 
Hi Nikola,

can you please answer my questions to proceed with the bug verification?
Thanks.
[18 Oct 2013 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".