I can't select "Database variant to data" in the functions palette

[Amanda_H]

Hi Rog,

Copying the files in order to obtain the toolkit in multiple versions of LabVIEW is not supported. I would recommend installing the toolkit to the version of LabVIEW you plan to use, such as 8.5, as this may correct the problem you are seeing.

[Rob_Calhoun]

Another option is to use the regular Variant to Data function. The only difference between the two was the handling of NULL values, and in LabView 8.5 variant NULLs passed to the regular Variant to Data function no longer throw an error. (That is possibly vexing if you were using the error to trap NULLs, but it's a better behavior in most cases.)

At this point we use only the regular Variant to Data function in our application, which makes heavy use of SQL Server databases. We connect to the database via ADO using ActiveX. (We in fact do not use the database toolkit at all anymore.)

-Rob