Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    PPR: EVENT.EVENT_XML gives error when called

    • Product: Voyager
    • Product Version: 9

    Problem Symptoms

    • Accessing EVENT.EVENT_XML in Microsoft Access gives error: ODBC--call failed. [Microsoft][ODBC Driver Manager] Function sequence error (#0)
    • Table data displays with #NAME? for all values.

    Cause

    This is an issue with MS Access which cannot handle columns with data type BLOB or CLOB. This data type applies to a handful of fields in the Voyager database, including EVENT.EVENT_XML.

    Resolution

    Omit fields with data type BLOB or CLOB from MS Access queries.

    Additional Information

    Replication steps:

    1. Install ODBC drivers & link tables for Voyager 9.0.0 Prepackaged Reports
    2. Under Tables, open EVENT table.
    3. Receive error: ODBC--call failed. [Microsoft][ODBC Driver Manager] Function sequence error (#0)
    4. Click OK.
    5. Table data displays with #NAME? for all values.

    Workaround

    Create query with all fields from EVENT table except EVENT_XML. Save query and use query instead of EVENT table for custom queries.


    • Article last edited: 05-Aug-2014