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
- Install ODBC drivers & link tables for Voyager 9.0.0 Prepackaged Reports
- Under Tables, open EVENT table.
- Receive error:
ODBC--call failed. [Microsoft][ODBC Driver Manager] Function sequence error (#0) - Click OK.
- 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