database connectivity toolkit SQL Book

[mrbean]

I'm using LabVIEW 8.21, and I'm trying to use the Database Connectivity Toolkit.  I've never worked with SQL, and I'd like to get a thorough book for our lab that we can reference when we need to write some SQL commands.  We're most likely going to use Microsoft Office Access 2003 (w/SP2) as our DB provider.  I've found hundreds of database/SQL books out there, so I'd appreciate some guidance, taking into account our toolset.  Thanks.

[Jaime Rodriguez]

The database Connectivity Toolkit User Manual has a chapter on SQL commands. I know this is not considered a thourough source of information but it has the majority of commands you will likely need in average applications.

Jaime

[Dennis_Knutson]

You'll also want to narrow your choices once you decide on the db you want to use. There are different implementations of SQL between the jet database that Access uses and SQL Server, for example. I don't remember the details but I was told there are a lot of things that can't be done with query in Access that you could easily do with a query in SQL Server, Oracle, or MySQL.

[michenglaoxu]

I am working with SQL server programming using LV Database Connectivity Toolkit now. To my experience, a general SQL programming book will be fine if you have DB design experience. Otherwise, you may need a genenral DB design introduction book too.

As for LV Database Connectivity Toolkit, there are some LV examples there, write a LV programm wouldn't be too difficult once your ODBC is setup ok.

If you use SQL Server or Desktop SQL, let your system administrator set up environment variables to make sure they are ok before you start programming. If you use Access, I believe the DB design part is more important and takes more time that Query in LV. Of courese, if DB table is also created dynamically in LV, the thing would be different.