From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
I am a new user in LabVIEW, and above all, a new user in SQL and Connectivity Toolset. I have an old program where the connection to the database is done by the SQL connect.vi, but in the examples I have found do they always use DB Tools Open Connectio.vi. What is the difference between these two? Does it matter which one I use? Or is it just a matter that the old program uses SQL Toolset and the examples I have found are reffering to The Connectivity Toolset?
The new one is based on something called ADO which is a database connection API from Microsoft. The Database Connectivity Toolkit replaced the SQL Toolkit several years ago. The SQL Toolkit used a completely different type of connection and you cannot mix the two. If you are doing new development, the DCT is the way to go.
