Hi,
I am not so sure where the data will be used, and this affects the solution. I use SQL servers quite often, and prefer using simple sql "SELECT" statements to gather the required data.(Even across multiple databases and schemas will multiple queries) Performing sanity logic, and required actions natively in LabVIEW is much easier and quicker. The only problem here is that bandwidth penalty of selecting an entire table. I usually only get columns that are actually needed, and only selecting large cells like "blobs" with very selective sql queries. I would recommend learning about sql commands and syntax.
The database connectivity toolkit will a 2d array of strings, which can hold almost every data type, which then can be converted to the correct data type.
Mike
