Page Comparison

Include Page

	_UserHeader
	_UserHeader

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 System	ODBC Tool Location
Windows 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"
1. 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:
1. Enter a name of your choice under Data Source Name.
2. Click the “Select” button to locate your database. Click "OK" and then click "OK" again to save.

Filter by label (Content by label)

true

This video demonstrates how to set up an ODBC connection to an Access database for use with the PopMedNet DataMart Client application.

Widget Connector

url	http://www.youtube.com/watch?v=CDjJCud5cSQ

Include Page

	_ContactUs
	_ContactUs