Archive

Posts Tagged ‘database’

Howto: Creating a Microsoft Data Link file (.UDL) for Connecting to Microsoft Access in LabVIEW

December 24th, 2008

A Microsoft Data Link file or Universal Data Link is a universal file that links to a specific database and can be used by many different applications.

UDL File Creation

The way a .UDL file is initially created depends on your Windows installation. This can be created  desktop shortcut menu.

  1. Right-click on the Desktop, or in the folder where you want to create the file.
  2. Select “New” from the shortcut menu. If Microsoft Data Link is listed, select it.
  3. Windows 2000 will most likely not have a Microsoft Data Link listed. If this is the case, please refer to the next section. Read more…

LabVIEW , , ,

How to write and read Access database in LabVIEW

December 18th, 2008

There are a couple of different methods to communicate with Access in LabVIEW, and some are more difficult than others. You can use ActiveX Automation to open Microsoft Access and control many aspects of the Access Application. For actual database manipulation however, the Access automation classes rely upon the Microsoft DAO (Data Access Object) and/or ADO (ActiveX Data Object) classes. These classes can be used independently or through the Access automation classes to read and write data into an Access database. These classes can be difficult to use and may require a fair amount of SQL knowledge to accomplish a complicated task.

For more information about the Microsoft Access automation classes, DAO or ADO classes refer to the Microsoft website and Developer Network. Read more…

LabVIEW , ,