Why Do I Recieve Error -2146825287 When Using the Database Connectivity Toolkit? Primary Software: LabVIEW Toolkits>>Database Connectivity ToolsetPrimary Software Version: 1.0 Primary Software Fixed Version: N/A Secondary Software: N/A
Problem: I use the DB Tools Execute Query VI to execute a SQL query, but 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: 06/17/2008 Document ID: 4MCG000U |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
