1 ratings:

4 out of 5

Rate this Document

Error -2147217904 during Database Query to MS Access from LabVIEW

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

Problem:

I am trying to write a query string to my database from LabVIEW using the Database Connectivity Toolkit's "DB Tools Execute Query.vi". The string I'm using works perfectly in MS Access, but when I run the LabVIEW program I get

Error -2147217904 Invalid string: specified field does not exist or contains an unsupported character.

What's wrong?

Solution:
First double check that if you're building your query programmatically, that the concatenated string query is, in fact, the query you need to send.

Also, check to see if you have the double quote character, ", in your query string. This character is supported in MS Access but not by SQL, which is the input string taken by the "DB Tools Execute Query.vi". Instead of the double quote character, ", use the single quote (tick), ', in your query string in LabVIEW. If you need to use the single quote (tick) character, ', instead you should use two ticks, ''.

Related Links:
Database Connectivity Toolset User Manual

Attachments:





Report Date: 12/29/2006
Last Updated: 02/26/2007
Document ID: 44S9NCZC

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.