Database application development - where to start., books, tutorials, etc

[BetterProcess]

I am starting to program a large database application (LV 6.1). There is going to be no machine control nor data collection in this program, only database interaction. I am looking for best practices for programming a large application, and information on database communication with LabVIEW. My background is solid in database design and data manipulation, but I am a basic LabVIEW programmer. Any recommendations on books or tutorials would be appreciated.

[Dennis_Knutson]

For genral LabVIEW information, you might want to start here and check your options for books and tutorials. As far as database connectivity, you've got a couple of options. NI sells the Database Connectivity Toolkit that you get information on here. What I've been using lately is LabSQL by Jeffrey Travis. This is a free open source toolkit. Both are based on ADO. The NI product is probably easier to use for people that aren't as familiar with the SQL language. With LabSQL, I debug my queries and stored procedures in the SQL Server Query Analyzer and then basically just paste them into
the input of a SQL Execute VI and the VI returns a string array that is the query results.