1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
|
+-------------------------------------------------------------+
| MySQL Connector/ODBC |
| Install on MS Windows |
+-------------------------------------------------------------+
INTRODUCTION
---------------------------------------------------------------
In this document we explain how to install MySQL Connector/ODBC
on MS Windows. Please read INSTALL if you have not done so already.
DISTRIBUTIONS
---------------------------------------------------------------
The following distributions are available for MS Windows;
MSI
This is a typical installer type for MS Windows which
will ensure that the files are copied properly and
that the driver is registered with the ODBC system.
This will work on any recent version of MS Windows and
is the preferred method to install Connector/ODBC on
MS Windows.
Simply double-click the msi file and follow installer
instructions.
ZIP (with installer)
This is an older style installer which comes in the
form of an exe called setup.exe. This is zipped to
reduce its size and to prevent it from being
accidently executed upon download or to otherwise
trip firewall and antivirus software.
This may work on some older MS Windows when the MSI
method is not supported.
Extract the setup.exe from the zip file and
double-click it to invoke the installer.
ZIP (no installer)
In this case you want to do the following;
1) Extract the files to the desired location using pkzip or
some compatible program.
2) Register driver by running Install.bat script from the
location where drivers were unziped.
3) Alternatively, you can register drivers manually using the
provided myodbc-installer utility. Run it without arguments
to see usage instructions.
NOTE: Do not try to edit the registery or odbc ini files
manually to register the driver unless you are
intimate with how to do this properly. myodbc3i has
been created for this purpose.
ZIP (source)
In this case you will want to do the following;
1) Extract the files (source code).
2) Build the source (see BUILD file for details).
2) Copy the files to the desired location and register them
as described above.
NOTE: If you need to reinstall and you are using Install.bat
then please consider using Uninstall.bat first. This
will ensure that the usage counter is not incremented
beyond the 1 you probably want.
POST INSTALL
---------------------------------------------------------------
Verify Driver Registered
Find the ODBC Administrator program in the
Start -> Control Panel and execute it.
Go to the Drivers tab and note that it has the MySQL ODBC
driver listed - this means that the driver is registered
with the ODBC system.
Alternatively you can run
> myodbc-installer -d -l
and see if the driver is listed. Run
> myodbc-installer -d -l -n "<name of the driver>"
to see deatailed information about the driver.
Create A Data Source Name
Data sources can be created with the myodbc-installer utility.
Run it without arguments to see usage instructions and examples.
Alternatively, you can define a data source with Windows
'ODBC Administrator' appliocation. Go to the 'User DSN' tab of
the 'ODBC Administrator' and create a new DSN. During this request
you will use a MySQL Connector/ODBC DSN window to edit the
connection information. This window has a 'Test' button which
allows you to Test your settings.
Save the DSN and exit the ODBC Administrator. You are now
ready to use MySQL Connector/ODBC.
Note: Prior to uninstalling a driver all data sources which use
that driver should be removed. It is not possible to remove a
data source after its driver has been uninstalled.
|
