MySQL ODBC drivers allow
you to connect to MySQL running on your Virtual Private Servers
and import/export databases to and from your own PC.
The following must be done on your own PC.
If you are using MS
Access 2000, it may be necessary to patch your MS Jet 4.0 database
engine before continuing. See the following, for more information.
Install the necessary
MySQL ODBC driver on your PC. Download the appropriate driver
Unzip the driver and
then run the setup program for the driver.
Configure the MySQL
driver for use.
Click "Start", point to "Settings", and then click "Control
Panel". Double click "Administrative Tools" and then double
click "Data Sources (ODBC)".
To do this go to your Control Panel (start -> setttings
-> control panel) and double click on ODBC icon.
You will then need
to select whether you want to configure the ODBC driver for
use by a single user or for use by every user on the computer.
The first tab, "User DSN" is for only a specific user and can
only be used on your specific computer. The second tab, "System
DSN" is used to configure the ODBC driver for all users on your
computer. Depending on which you choose to use, you will then
click the add button on the right side. By clicking the add
button you will be given a choice of drivers you can set up
for a data source. You should find MySQL in the list. Select
MySQL and click finish.
The TDX mysql driver
default configuration screen will then appear. You will want
to fill out the fields with the appropriate information.
Type a name for this particular driver that you will be
using for MySQL. The name is something of your choosing.
This is the name of the Virtual Private Servers you will
be publishing your database to. (example: myserver.net)
This needs to be the name of the MySQL database you will
be connecting to.
This needs to be the username for the MySQL database you
will be connecting to.
Simply the password, if applicable for the MySQL user in
the field above.
If you are behind a Firewall you will need to open up port
3306 or another port you specify or it will not work correctly.
||Exporting an MS Access Database to MySQL
Using these Windows MySQL ODBC drivers you can export Microsoft
Access databases from your PC directly to your Virtual Private
Servers running MySQL.
MySQL on your Virtual Private Servers. Be aware that
you will need to consult the MySQL documentation for information
on using MySQL.
Add a user, with password
privileges if you like, to your MySQL database. See the following
section of the MySQL
Open up MS Access and
create or select the database you want to move to your Virtual
Private Servers in the Tables section. Once you have selected
the appropriate table, select Save As/Export under File. This
will allow you to select the "To an External File or Database"
option. Click OK.
The Save Table screen
will appear. You will want to select the field and then change
the "Save as type" to ODBC Databases and click Export.
The Export screen appears.
The "Export Addresses to:" should simply be the name you want
to call this specific database table on the Virtual Private
The "Select Data Source"
screen should then appear. Select the "Machine Data Source"
tab and then select the Data Source Name you should have set
up previously in step 7a.
The table should then
be moved to the Virtual Private Servers under the user you specified
for MySQL. To verify this, connect to your Virtual Private Servers
via Telnet or
SSH and find the table. An example of this would be
% mysql -u
<user name> <mysql or other database instance>
||Importing a MySQL Database to MS Access
It is also possible to import MySQL databases from your Virtual
Private Servers to your PC running MS Access.
While in the Tables
tab right-click on the mouse button. This will provide you an
option for "Import". In the Import screen select ODBC in the
"Files of type" field.
This will provide you
the "Select Data Source" screen. You will again select the "Machine
Data Source" tab and choose the appropriate "Data Source Name"
that you setup previously.
The "Import Objects"
screen will appear and you will be given a choice of available
tables on the Virtual Private Servers that you can choose from.
Select the table you want and click OK.
Now you have the appropriate
table from the Virtual Private Servers on your computer for
use within MS Access.
Toll Free 1-866-GSP-4400 • 1-301-464-9363 • email@example.com
Copyright © 1994-2016 GSP Services, Inc.