26.1.3. How to Install MyODBC
MyODBC works on Windows 9x, Me, NT, 2000, XP, and 2003, and on
most Unix platforms.
MyODBC is Open Source. You can find the newest version at
https://dev.mysql.com/downloads/connector/odbc/. Please note
that the 2.50.x versions are LGPL licensed, whereas the 3.51.x
versions are GPL licensed.
If you have problem with MyODBC and your program also works with
OLEDB, you should try the OLEDB driver.
Normally, you need to install MyODBC only on Windows machines. You
need MyODBC for Unix only if you have a program like ColdFusion
that is running on a Unix machine and uses ODBC to connect for
database access.
If you want to install MyODBC on a Unix box, you also need an ODBC
manager. MyODBC is known to work with most Unix ODBC managers.
To make a connection to a Unix box from a Windows box with an
ODBC application (one that doesn't support MySQL natively),
you must first install MyODBC on the Windows machine.
The user and Windows machine must have access privileges for
the MySQL server on the Unix machine. This is set up with the
GRANT command. See Section 13.5.1.3, “GRANT Syntax”.
-
You must create an ODBC DSN entry as follows:
Open the Control Panel on the Windows machine.
Double-click the ODBC Data Sources
32-bit icon.
Click the tab User DSN.
Click the Add button.
Select MySQL in the screen Create New Data
Source and click the Finish
button.
The MySQL Driver default configuration screen is shown.
See Section 26.1.9.2, “Configuring a MyODBC DSN on Windows”.
Start your application and select the ODBC driver with the DSN
that you specified in the ODBC administrator.
Notice that other configuration options are shown on the MySQL
screen that you can try if you run into problems (options such as
trace, don't prompt on connect, and so forth).
