Below is a general guideline for creating DSN files. For more in depth information and information about 64-Bit ODBC Drivers, please check Microsoft's tutorial on how to Connect to an ODBC Data Source (SQL Server Import and Export Wizard).
For a User or System DSN
-
Navigate to Control Panel»Administrative Tools»ODBC Data Sources (32-Bit). In older versions of Windows this may be listed as Data Sources (ODBC).
-
Select either the User DSN or System DSN tab.
-
Select Add»Microsoft Access Driver (*.mdb, *.accdb)»Finish.
-
Give it a Data Source Name and a good description.
-
Choose the Select button in the Database field.
-
Navigate to the location of your Access database and select OK.
-
Select OK on the ODBC Microsoft Access Setup window.
-
You should now see your DSN in the User/System Data Source window.
For a File DSN
-
Navigate to Control Panel»Administrative Tools»ODBC Data Sources (32-Bit). In older versions of Windows this may be listed as Data Sources (ODBC).
-
Select the File DSN tab.
-
Select Add»Microsoft Access Driver (*.mdb, *.accdb)»Next.
-
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.
-
Select Next»Finish.
-
Choose the Select button in the Database field.
-
Navigate to the location of your Access database and select OK.
-
Select OK on the ODBC Microsoft Access Setup window.
-
Select OK on the ODBC Data Source Administrator window.
-
The DSN file should now be located in the location you specified in step 4.
You will now have created a DSN file that is able to be access in LabVIEW using the LabVIEW Database Connectivity Toolkit.