Creating the ODBC Connection
This documentation references PopMedNet 2021.1 +
PopMedNet User's Guide
Based on version 2021.1 +
Creating the ODBC Connection
If your database is stored in Microsoft Access, you must create an Open Database Connectivity (ODBC) connection to your data source.
Follow these steps to create an ODBC connection:
Navigate to the ODBC Data Source Administrator Tool:
Operating SystemODBC Tool LocationWindows XP Control Panel > Administrative Tools > Data Sources (ODBC) Windows 7 Search "ODBC" in the Windows search bar and select "Data Sources (ODBC)" or navigate to Control Panel > System and Security > Administrative Tools > Data Sources (ODBC) - Click on the System DSN tab and click the "Add" button.
- In the Create New Data Source window, choose Microsoft Access Driver (*.mdb, *accdb) and click "Finish"
- If you do not have Microsof Access Driver as an option, you must download the drivers manually. Access drivers are no longer automatically included with the DataMart client. Microsoft Access Database Drivers can be downloaded here:https://www.microsoft.com/en-us/download/details.aspx?id=13255
- Enter the Data Source Name and locate the database:
- Enter a name of your choice under Data Source Name.
- Click the “Select” button to locate your database. Click "OK" and then click "OK" again to save.
This video demonstrates how to set up an ODBC connection to an Access database for use with the PopMedNet DataMart Client application.