Create a DSN File to Use With LabVIEW Database Connectivity Toolkit

Updated May 7, 2021

Environment

Software

  • LabVIEW Database Connectivity Toolkit

This article provides general guidelines for creating a Data Source Name (DSN) for use with the LabVIEW Database Connectivity Toolkit. The steps will use a Microsoft Access database as an example. For more information on connecting to an ODBC data source, refer to the Microsoft documentation.

User or System DSN

  1. Navigate to Control Panel » Administrative Tools » ODBC Data Sources (32-Bit).  In older versions of Windows, this may be listed as Data Sources (ODBC).
  2. Select either the User DSN or System DSN tab.
  3. Select Add » Microsoft Access Driver (*.mdb, *.accdb) » Finish.
  4. Give it a Data Source Name and a good description.
  5. Choose the Select button in the Database field.
  6. Navigate to the location of your Access database and select OK.
  7. Select OK on the ODBC Microsoft Access Setup window.
  8. You should now see your DSN in the User/System Data Source window.

File DSN

  1. Navigate to Control Panel » Administrative Tools » ODBC Data Sources (32-Bit).  In older versions of Windows, this may be listed as Data Sources (ODBC).
  2. Select the File DSN tab.
  3. Select Add » Microsoft Access Driver (*.mdb, *.accdb) » Next.
  4. Navigate to the DSN file you wish to use via the Browse button (the name of the file should have a .dsn file extension), or manually type in the file path. 
  5. Select Next » Finish.
  6. Choose the Select button in the Database field.
  7. Navigate to the location of your Access database and select OK.
  8. Select OK on the ODBC Microsoft Access Setup window.
  9. Select OK on the ODBC Data Source Administrator window.
  10. The DSN file should now be located in the location you specified in step 4.

You will now have created a DSN file that can be used by the DB Tools Open Connection VI from the Database Connectivity Toolkit.