How do I send SQL statement to SQL Server and return data without using Database Connectivity Toolkit?

[Jesse_Larsen]

Hi,  I've been trying to figure out how to pull data out of my SQL Server databases and from reading some posts and doing some tests with examples, I can kind of get data connecting into my SQL server, but so far nothing that helps.  Is it possible to actually get data out of a SQL Server database without using the Database COnnectivity Toolkit?  and if so, how?  are there whitepapers and/or examples of this?  So far, I cannot find anything that works.  thanks.

[BowenM]

I haven't ever done it before in LabVIEW and don't have the time to do much of the research right now.

That having been said, you will want to look for either a .NET library or an ActiveX control. Aside from the toolkit, you aren't going to find a native solution to LabVIEW - which means using other libraries. A quick google search returns this:

http://msdn.microsoft.com/en-us/library/ms810810.aspx

which may help.

[dkfire]

I found a old post over at the other side, that talks about connection to SQL databases:

http://lavag.org/topic/7240-best-way-to-interface-labview-to-sql-server/

One tool I have seen is LabSQL, try to search for that.

[Eric1977 · Accepted solution]

Jesse - What is your reason for not using the Database Connectivity Toolkit? That is by far the easiest way to grab data.