Archived:How to Create a DSN File to Communicate with an Access Database in LabVIEW

Updated Feb 2, 2018

National Instruments does not actively maintain this document.

This content provides support for older products and technology, so you may notice outdated links or obsolete information about operating systems or other relevant products.

Reported In

Software

  • LabVIEW 1.0 Database Connectivity Toolkit

Issue Details

I have a Microsoft Access database with which I want to communicate in LabVIEW through the Database Connectivity Toolkit. How do I create a Data Source Name (DSN) file for my database?

Solution

For a User or System DSN
  1. Select Start»Settings»Control Panel»Administrative Tools»Data Sources (ODBC) in Windows 2000/XP or Start»Settings»Control Panel»Data Sources (ODBC) in Windows 9x/Me.
  2. Select either the User DSN or System DSN tab.
  3. Select Add»Microsoft Access Driver (*.mdb)»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.
For a File DSN
  1. Select Start»Settings»Control Panel»Administrative Tools»Data Sources (ODBC) in Windows 2000/XP or Start»Settings»Control Panel»Data Sources (ODBC) in Windows 9x/Me.
  2. Select the File DSN tab.
  3. Select Add»Microsoft Access Driver (*.mdb)»Next.
  4. Type the name of the DSN (the name of the file should have a .dsn file extension).
  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.

WAS THIS ARTICLE HELPFUL?

Not Helpful