07-10-2025 03:35 PM
I developed an application on LV 2020 32 bit that uses the Database Connectivity Toolkit.
It was working fine with Windows 10.
Now with windows 11, it is giving an error when inserting data into the database.
I was able to find the point where the error occurs. This error happens on the LabVIEW library
Anyone has faced this issue ? Any help is appreciated.
I'm not sharing my code since the issue happens on the LabVIEW libraries.
07-10-2025 04:53 PM
That error number is one that should only occur when you try to reference a table or view with a name that doesn't exist. Hint: If you tried to Google this error and got no results, it's because you can't Google negative numbers since it thinks that means you're excluding that from your results. If you get a negative error number and need to look it up, remove the minus sign and it'll still return results.
Best guess, the source of the error is probably one of two things:
07-11-2025 10:23 AM
Thank you for your message.
the error happens on the NI library vi, and also happens when running the example shipped NI Database toolkit.
If i was to try implement option number 2, do you happen to know any reference for this implementation on windows 11 (about the string) ? If that's the case then the NI libraries will need to be modified.
07-11-2025 02:42 PM
Best guess is that you try running a "list all tables" command that matches your database type:
https://www.sqltutorial.org/sql-list-all-tables/
Then make sure you copy the table name back exactly as delivered to you.
07-11-2025 05:07 PM - edited 07-11-2025 05:08 PM
When creating the object ADODB._Recordset.Open - source is wired to ADODB._Command that's when the error happens.
It worked fine with Windows 10, this is LV 2020 (32Bit), SQL Server Native Clienc 11.0
I wonder if anything got lost with new versions.