Database problem - Execute() The specified table does not exist. RRS feed

  • Question

  • I am using SQL server compact edition 3.5 (version 3.5.8154) OLE deployed through Windows Embedded Compact 7 platform builder. My Execute command is failing. Note, this statement works fine on Windows CE6 with SQL 3.5 version 3.5.5692.

    At this line of c++ code:

    m_hrLastError = pCommandText->Execute(NULL,    IID_IRowset, NULL, NULL, (IUnknown **)&pIRowset);

    Execute failed:

    SQL Statement: [select table_name, column_name, data_type, character_maximum_length from information_schema.columns]

    OLE DB Error:

    HRESULT: 80040e37,

    Minor Code: 0,

    Source: Microsoft SQL Server Compact OLE DB Provider,

    Description: The specified table does not exist. [,,,,,]

    How do I resolve this issue?



    • Edited by cladden01 Friday, October 5, 2012 6:28 PM
    Friday, October 5, 2012 5:57 PM

All replies

  • I don't think we know enough to answer. It seems most-likely that you have misnamed a table in your CE7 database and the error is correct. Without some view of the database structure and the code leading to the Execute() method call, we don't have any clues.

    Paul T.

    Monday, October 8, 2012 3:04 PM