locked
Power Pivot RRS feed

  • Question

  • Hi, I really need some help here.

    I am currently using Windows XP Pro 2002 SP3 . Testing on Power Pivot Excel add-in.

    Power Pivot Data connections via Data Source (OLE DB/ODBC).

    And running Interbase 2009 database.

    Currently I encounter an error message shown as below when clicking on Preview & Filter button after check mark a table in Table Import Wizard:-

    OLE DB or ODBC error: [DataDirect][ODBC InterBase driver][InterBase]Dynamic SQL Error, SQL error code = -104, Token unknown - line 1, char 7, [; 37000.
    An error occurred while processing the 'PROCORD1' table.
    The operation has been cancelled.

    The fact is that all other tables also facing the same issue when I click on Preview & Filter button.

    However,I was able to write a query to specify the data to import and proceed to create Pivot Charts and tables.

    Questions

    1) Do you think this is related to the ODBC driver that I'm currently using ? If no what is the other most possible reasons?

    2)Is the ODBC Driver- Data Direct Version 05.10.0044 (B0099,U0055) , File Date:10/17/2007 that I'm using compatible with Microsoft Power Pivot?

    3)Usually what does this SQL error means "Dynamic SQL Error, SQL error code = -104" ?

    Thursday, July 8, 2010 11:10 AM

Answers

All replies