Admin Manual - Installing an ODBC Connection

From PikaDocs

ODBC Overview

Open Database Connectivity (ODBC) is standard interface for accessing databases. Many applications, including Microsoft Access and Microsoft Word, can use any data source that is made available via ODBC. To connect these applications to your Pika database, you'll need to install the MySQL ODBC, or MyODBC, drivers, and then set up an ODBC connection that points to your database. This only needs to be done once, on any PC which will be using ODBC.

Installing the MyODBC Drivers

1. Go to MySQL.com.
2. Click on the Downloads tab.
3. Scroll halfway down the page and click on the "Connector/ODBC 3.51" link.
4. Find the Windows Downloads section, and click on Driver Installer Download link.
5. Save the file to your hard drive.
6. Double click the file you just downloaded.
7. Click Next.
8. Click Next.
9. Click Next.
10. Click Finish.

Creating an ODBC Connection

1. Open the Control Panel
2. Double Click the Data Sources (ODBC) icon. On some versions of Windows this is hidden under Administrative Tools or Performance and Maintenance then Administrative Tools.
3. Click on System DSN tab
4. Click on Add...
5. Select MySQL ODBC 3.51 Driver from the list, then click Finish
6. Choose a Data Source Name (DSN) that describes this connection. Enter the network name or IP address of the MySQL server. Enter the name of the database to be used. Enter the user name and password. Finally, the Options button and check the box labeled "Return matching rows", which is required by Microsoft Access. Click OK.
7. The DSN for the new connection should now appear on the System DSN list. Click OK to finish configuring ODBC.

Document Assembly | Reporting with Microsoft Access

Table of Contents