Home
FrontPage Hosting
mySQL Hosting
Dedicated Servers
Managed Services
Domain Parking

Search our FrontPage Support Area
FrontPage Support Area Site Map

ODBC with mySQL

NOTE:  You must have a mySQL database table or tables set up in order to access the database.

Requirements: Windows 95 or NT 4.0

1. Download the ODBC Download myodbc 2.50.xx for Windows95 or NT from here.
2. Unzip the file into a temp directory and run program "setup.exe"
3. From the "Install Drivers" window, choose MySQL.
4. After installing the MySQL ODBC driver, the install program will show the "Data Sources" window. Click "Add."

Note: On Windows NT 4.0, you'll get a message saying "This application uses the old version of CTL3D32.DLL..." Just ignore
it for the moment.

5. From the "Add Data Source" Window choose MySQL from the list box and click the OK button.
6. Fill out the fields in the DSN setup window.
1. You can use any unique identifier for the Windows DNS name and description
2. Enter the name of the "mySQL Database"^*
3. Enter the server name^*
4. Enter the "user"^*
5. Enter your password for "password"^*
6. Enter the port number^*
7. Click on OK.

^*Get these values from your server administrator or provider technical support.

This will setup a MySQL DSN on your local PC.

You may start using the MySQL Data Source in your PC programs.

How to set up MS Access 97 to access your mySQL database via ODBC

1. Open MS Access and create a new database.
2. From the file menu, choose File and then Get External Data and then Link Tables.
3. From "Link" window that comes up, choose ODBC Databases.
4. From the "Select Data Source" Window, choose the DSN name you've setup for your online mySQL database. If you haven't already done so, see instructions here. Click the OK button.
5. From the "Link Tables" window, select the table you want to attach and click the OK button.
6. ODBC could prompt you for the primary key column in that table, if it can't find it. Specify one and that's it! The online mySQL table is now attached to your local access database:
7. You may open the table, update, inset or delete records. To attach all database tables, follow the above steps for each table in your database.