These provider specific errors are typically thrown when preparing a SQL command for execution. With FOR XML, this becomes more interesting. Some errors, such as those triggered by NULL columns, occur only at execution time.
Possible errors include:
The following errors are caused by bad names within the application definition or column/table aliases in the query.
Symbol | Description |
---|---|
E_NAMESTART | Start character is not a letter, underscore or colon |
The following errors may occur as the XML is being generated.
Symbol | Description |
---|---|
WR_E_NONWHITESPACE | writer: specified string is not whitespace |
WR_E_NSPREFIXDECLARED | writer: namespace prefix is already declared with a different namespace |
WR_E_NSPREFIXWITHEMPTYNSURI | writer: It is not allowed to declare a namespace prefix with empty URI (for example xmlns:p=””). |
WR_E_DUPLICATEATTRIBUTE | writer: duplicate attribute |
WR_E_XMLNSPREFIXDECLARATION | writer: can not redefine the xmlns prefix |
WR_E_XMLPREFIXDECLARATION | writer: xml prefix must have the http://www.w3.org/XML/1998/namespace URI |
WR_E_XMLURIDECLARATION | writer: xml namespace URI (http://www.w3.org/XML/1998/namespace) must be assigned only to prefix "xml" |
WR_E_XMLNSURIDECLARATION | writer: xmlns namespace URI (http://www.w3.org/2000/xmlns/) is reserved and must not be used |
WR_E_NAMESPACEUNDECLARED | writer: namespace is not declared |
WR_E_INVALIDXMLSPACE | writer: invalid value of xml:space attribute (allowed values are "default" and "preserve") |
WR_E_INVALIDACTION | writer: performing the requested action would result in invalid XML document |
WR_E_INVALIDSURROGATEPAIR | writer: input contains invalid or incomplete surrogate pair |
The following errors are triggered by bugs within the data provider itself.
E_NOOUTPUTSTREAM | Output stream was not set |
SQL Statements Accepted by the Data Provider
See Help on Help for additional information on using this help file. See Scantron Technical Support for additional information on technical support and training options. See the ScanTools Suite System Requirements for further details on hardware and software requirements. ScanTools is a suite of products; the specific information you want may appear in the help for a different module. If you don't find what you're looking for here, try one of the following:
|
Scantron Corporation
Customer Service (forms, products, and services): 1-800-SCANTRON (722-6876) Technical Support: 1-800-445-3141 |
|
Copyright © 1998-2012 Scantron Corporation. All rights reserved. Use permitted only under license. www.scantron.com. No part of the Help or user guides may be reproduced in any form, or by any means, without express permission from Scantron Corporation. LINKS TO THIRD PARTY SITES This help system may contain links to third party websites ("Linked Sites"). The Linked Sites are not under the control of Scantron and Scantron is not responsible for the content of any Linked Site, including without limitation any link contained in a Linked Site or any changes or modifications to a Linked Site. Scantron is not responsible for web casting or any other form of transmission received from any Linked Site. Scantron provides Users with the ability to link the Assessment System to the Linked Sites as a convenience to you, and the inclusion of any link does not imply endorsement by Scantron of the Linked Site or any association with its operators. |