Mar 05 2020

This website is hosted by HostGator. How to configure MySQL server 4. Select the Advanced tab. This will help you to identify the DSN when using it from applications such as Excel that are only compatible with the bit driver. Here we choose northwind.

Uploader: Faugor
Date Added: 15 November 2007
File Size: 34.86 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 32127
Price: Free* [*Free Regsitration Required]

Refer to MySQL installation guide here. Short for D ata S ource N ame.

This website is hosted by HostGator. Now fill in connection information about how to connect to a database in MySQL. On the Start menu, click Control Panel.

Steps to install PHP 5. Socket sets the name or location of a specific socket or Windows pipe to use when communicating with MySQL.

How to configure MySQL server 4. In the Password field, enter the corresponding password for this connection. Tip Because it is possible to create DSN using either the bit or bit driver, but using the same DNS identifier, it is advisable to include the driver being used within the DSN identifier.


The default is localhost. In the Data Source Name box, enter the name of the data source you want to access. You now need to configure the specific fields for the DSN you are creating through the Connection Parameters dialog. By default, it is localhost.

MySQL ODBC driver installation

We choose to create a System DSN. A unique name here to identify this data source. The default database name used when connecting to MySQL server. The interfaces for the 3. DSN info is stored in the registry. Click Test button to make sure the connection information you just entered is correct. In the Following chapter we will see how to install: We cclick next on the Add button, a list of driver is displayed. The Details button opens a tabbed display which allows you to set additional options:.

How to configure MySQL server 5. User DSN — created for a specific user. odbbc

MySQL Connector/ODBC 3.51

GeeksEngine is hosted by HostGator. Pre-requisites The following two programs must be installed on your computer before you proceed.


How to install Apache 1. No portion may be reproduced without my written permission. Click on the Test button. Add your own comment.

How to install MySQL server 4. The next screen show the readme infos The installation proceed and files are copied. If the connection failed, you can obtain more information on the test and why it may have failed by clicking the Diagnostics You can configure a number of options dobc a specific DSN by using the Details button.