Tag Archives: Database Connectivity Toolset

A Note about Using Database Connectivity Toolset in LabVIEW

Posted by on March 8, 2009 No comments

The Database Connectivity Toolset is a great add-on toolkit for LabVIEW, it makes the database operation within LabVIEW so easy that you can operate database even without sound knowledge of database.

I used this toolkit in one of my projects to record the test results of UUTs into MS Access database. I created a save results to database subVI with this toolkit. The subVI looks like this:

Origin LabVIEW subVI 

Read more »

Access Different Access Database Files Programmatically in LabVIEW with Database Connectivity Toolset

Posted by on January 16, 2009 2 comments

One of my project needs to save test results to different Access database files for different units to be tested. The database files’ name is automatic generated based on UUT’s serial number. Currently, I’m using the LabVIEW Database Connectivity Toolset, and the default method to access a database file by it is UDL file. The UDL file contains only one static database file and it is quite hard to change it programmly without manually select a database file and click the confirm button.  And it will be a nightmare to create each UDL file for each UUT before the test is taken.

To change the UDL file’s content in LabVIEW programmly is not easy too. Because UDL file  is unicode-formatted, and LabVIEW is quite limited in support to unicode. I had tried several ways to change the database file name in UDL file and save the UDL file to hard disk. And when I open the changed UDL again, I got “File corrupted” message. It seemed that it is not a good way. Read more »