ni.com is currently undergoing scheduled maintenance.

Some services may be unavailable at this time. Please contact us for help or try again later.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Use LabVIEW to check Duplicate values in SQL

I am trying to use LabVIEW Database Connectivity tool to Execute a SQL Query to check for duplicate values in the table. 
But I am seeing this error -2146825023 after the Database Fetch VI is executed.

Looking for some guidance.

 

Thank you.

0 Kudos
Message 1 of 3
(1,480 Views)
The information is really not enough. The error code is not a labview error code. It is an error from the ODBC Connector. I'm missing ... - which database and which connector you are using. - the database structure - your code (at least the SQL command) - the complete error message last but not least: this is a labview forum and not a forum for SQL.
0 Kudos
Message 2 of 3
(1,456 Views)

 

adErrItemNotFound 3265 -2146825023 0x800A0CC1 Item cannot be found in the collection that corresponds to the requested name or ordinal.

ErrorValueEnum - ActiveX Data Objects (ADO) | Microsoft Learn

G# - Award winning reference based OOP for LV, for free! - Qestit VIPM GitHub

Qestit Systems
Certified-LabVIEW-Developer
0 Kudos
Message 3 of 3
(1,392 Views)