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 want to create a connection with SQL data base with the help of connection string by using active X automation in Labview. I do not want to use the pop-up (Dialogue of database) use to configure the connection (selecting database, server name, user name & password etc).
Create a text document on your desktop, rename it something with a .UDL extension, and then double click the file to setup the connection properties. After configuring and testing the connection, click OK. Now right click the file and open it with a text editor like Notepad or WordPad. You will find a connection string that you can use in the DB Toolkit.
aputman ------------------ Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
Or you can just pass the UDL file path into the Open Connection of the Database Toolkit and it will do it all for you.
There are only two ways to tell somebody thanks: Kudos and Marked Solutions Unofficial Forum Rules and Guidelines "Not that we are sufficient in ourselves to claim anything as coming from us, but our sufficiency is from God" - 2 Corinthians 3:5
Actually I have created the connection string after configuration the connection as u told in the post. But Now I want to stablish the connection everytime using the LabVIEW.
Thanks Crossrulz,
Actually I do not have Database tool kit on my PC. So I want to use Active X automation VI to perform the action. Can you help me in configuring the connection using Active X.
Do a search for LabSQL. There may be other toolkits but this is the one I used before I got the NI toolkit.
aputman ------------------ Heads up! NI has moved LabVIEW to a mandatory SaaS subscription policy, along with a big price increase. Make your voice heard.
