Using WebDB with Desktop Applications
To use your MySQL database with Microsoft Access and other desktop applications, you need MyODBC, the ODBC (Open Database Connectivity) Driver for MySQL. You can download MyODBC from http://dev.mysql.com/downloads/connector/odbc/.
Configuring ODBC in Windows
After downloading and installing the driver, you must configure it. From the Windows Control Panel, double-click on Administrative Tools, then on Data Sources (ODBC). You will see the dialog box below. Click on Add…. When prompted, choose any of User DSN, System DSN, or File DSN.
The “Create New Data Source” dialog box appears. Click on MySQL ODBC 3.X Driver.
Fill in the required info for the DSN (Data Source Name) dialog box:
Data Source Name (a descriptive name of your choosing) Description (a description of this connection) Host/Server Name (or IP)
Database Name (the database name given to you when your database was created) User (the MySQL account name given to you) Password (your MySQL account password) Port
SQLcommand on connect (leave blank)
Click OK. If you manage multiple databases, repeat this process to create a DSN for each.
Configuring ODBC in Your Application
We will use Microsoft Access as an example, but the process is similar for other applications.
In Microsoft Access, create a new database.
From the File menu, choose “Get External Data” → “Link tables…”.
The “Link” dialog box appears.
At the bottom of this window, click on the “Files of Type” drop-down list and select “ODBC Databases”.
The “Select Data Source” dialog box appears. If you created the ODBC Data Source as a "user" or "system" DSN, click the Machine Data Source tab to find the data souce defined above. Select your data source.
The application attempts to contact the dtabase werver on host webdb.uvm.edu. When it des (if it does), select the tables you wish to work with.
These tables are now linked "live" to your remote database. Any changes you make occur instantly across the network.
- If you are off-campus, you must start the VPN client and log onto the campus network before attempting to connect.
If you receive an error message suggesting that
your_account_name@"132.198.%"is not authorized to connect, go back to the ODBC control panel and double-check the DSN configuration. Be sure everything is spelled and capitalized correctly.
- if errors persist, contact Systems Architecture & Administration for assistantance. Please include the text of the error message, your database name, you MySQL user name, and anything else you miight think is important.