What Does an ODBC Error From the Database Toolkit Mean?Primary Software: LabVIEW Toolkits>>Database Connectivity ToolsetPrimary Software Version: 1.0 Primary Software Fixed Version: N/A Secondary Software: LabVIEW Toolkits>>Enterprise Connectivity Toolset
Problem: When running my VI that accesses the Database Connectivity functions, I receive an error thrown by the Microsoft ODBC Provider that LabVIEW doesn't interpret. What does this error code mean? Solution: Since the error is thrown by the Microsoft ODBC Provider itself when it attempts to execute the database commands, LabVIEW can only return the error code that ODBC returns. Microsoft keeps a listing of error codes with their associated explanations, a copy of which is attached below as OLEandOLEDBProviderErrorswithADO.txt. You can search this document to find error codes that you receive. One of the more common error codes, "-2147217900 The command contained one or more errors", implies that the SQL command being sent to the database has not been formatted correctly, and is returned when a user-defined query contains a syntax error. Related Links: Attachments:
Report Date: 02/07/2006 Last Updated: 02/27/2006 Document ID: 3U6CSQPZ |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
