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.


    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


All replies