Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    PPR: EVENT.EVENT_XML gives error when called

    • Article Type: General
    • 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.

    Category: Prepackaged Rpts - Voyager

    Subject: Voyager


    • Article last edited: 8/5/2014
    //doorbell.io feedback widged