Using LV 8.6 to access database created in MS SQL Server Management Studio

[sbk143]

I am using Labview 8.6 to access a database created in MS SQL Server Mgmt Studio, using LabSQL ADO utilities. I don't have LV's add-on DB connectivity toolkit, but just the ADO utilities. Can i do it? If yes, how? I have no experience whatsoever in connecting and accessing data from a DB. An example would help.

Thanks,

[Silver_Shaper]

As for my opinion you cant access without DB connectivity toolkit.

[Dennis_Knutson]

---

@Szi wrote:

As for my opinion you cant access without DB connectivity toolkit.

---

Nonsense.

With LabSQL, you should first find an on-line SQL tutorial and refer to the Microsoft help files. I would recomend creating a UDL file. This is the connection string you use for the ADO Connection Open function. You might want to to get a little help from the db administrator. You'll certainly need help in getting a login and password.

There are examples that come with LabSQL

[ABCPrograms]

Indeed Denis,

LabSQL works perfectly fine. 

[sbk143]

How do I create UDL file for a database created in sql server management studio?

[Aaron O]

That might be a question that is better suited for MSDN, considering this is a Microsoft product. It might helpful to look over the documentation here: http://msdn.microsoft.com/en-us/library/ms174173.aspx