Web Hosting Support Area for MYSQL 
Setting Up the MyODBC Driver

Another way of connecting is through the use of ODBC. Although ODBC is currently not supported from the Web hosting servers, it may be installed locally on your home or office workstation. It provides a convenient way to upload and download data to the MySQL server.

It is necessary to obtain the MyODBC drivers from the MySQL Web site. Once installed, a number of different ODBC compliant applications (such as MS Excel and MS Access) can be configured to connect to the database.

The MyODBC driver must be installed correctly on the client workstation using the values given below for database, hostname, username and password. In addition, if required, the port is 3306.

The MyODBC drivers can be found at: http://www.mysql.com/downloads/api-myodbc.html for Windows 95/98/NT and Unix client workstations.

To configure your PC for a MyODBC connect with MS Access/Excel you need to go to the link above and download the 1.47MB file (myodbc-2_50_24-win95.zip) from the following link: "MyODBC 2.50.24 for Windows95 (full setup)"

After downloading to your desktop, create a folder called myodbc and unzip the downloaded file to the folder. Inside the MyODBC folder there is a Setup.exe file that will install the MyODBC. Before attempting to install the driver, be sure to close all windows programs first. After set up you must configure the driver for a connection.

To configure the MyODBC driver:

  • Highlight the MyODBC driver, click CONFIGURE.
  • Windows DSN Name: yourusername
  • MySQL Host: (The IP will be issue at sign up)
  • MySQL Database Name: yourusername
  • User: yourusername
  • Password: yourpassword
  • Port: (Leave empty)
  • SQL Command on connect: use yourusername
  • Leave all the check boxes blank, click OK.