sql database connection using active x in labview

[R.V.]

Hi, 

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).

Thanks for any suggestion

[aputman]

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. 

[crossrulz]

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.

[R.V.]

Thanks Aputman for the reply,

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.

[aputman]

Do a search for LabSQL.  There may be other toolkits but this is the one I used before I got the NI toolkit.