This Document is not yet Rated

Rate this Document

Why Do I Receive Error -2146825287 When Using the Database Connectivity Toolkit?

Primary Software: LabVIEW Toolkits>>Database Connectivity Toolset
Primary Software Version: 1.0
Primary Software Fixed Version: N/A
Secondary Software: N/A

Problem:
When I use the DBToolsExecuteQuery.vi to execute a SQL query, it returns Error -2146825287. My SQL query looks to be correctly formed. Why am I getting this error?

Solution:

This error is returned when the arguments are of the wrong type. This is most commonly encountered when a numeric is accidentally placed in single quotes, which the SQL interprets as a string. If the table column is expecting a numeric, the DB Tools Execute Query VI will return Error -2146825287.

For example, change UPDATE MY_TABLE SET A = '5'; to UPDATE MY_TABLE SET A = 5;

Related Links:
KnowledgeBase 2FKFIAYY: Error -2147217913 from the LabVIEW Database Connectivity Toolset
KnowledgeBase 2INHBEVS: Using Boolean Data Type with the LabVIEW Database Connectivity Toolset
Product Manuals: Database Connectivity Toolset User Manual (May 2001)

Attachments:





Report Date: 06/13/2008
Last Updated: 10/23/2008
Document ID: 4MCG000U

Your Feedback!	Poor  |  Excellent							Yes	No
Document Quality?							Answered Your Question?
	1	2	3	4	5
Document needs work? Please tell us why.
Please Contact NI for all product and support inquiries.