Connector/ODBC Examples
1774
20.1.5.2. Step-by-step Guide to Connecting to a MySQL Database through Connector/
ODBC
A typical situation where you would install Connector/ODBC is to access a database on a Linux or Unix
host from a Windows machine.
As an example of the process required to set up access between two machines, the steps below take
you through the basic steps. These instructions assume that you connect to system ALPHA from
system BETA with a user name and password of
myuser
and
mypassword
.
On system ALPHA (the MySQL server) follow these steps:
1. Start the MySQL server.
2. Use
GRANT
to set up an account with a user name of
myuser
that can connect from system BETA
using a password of
myuser
to the database
test
:
GRANT ALL ON test.* to 'myuser'@'BETA' IDENTIFIED BY 'mypassword';
For more information about MySQL privileges, refer to
Section 6.3, “MySQL User Account
Management”
.
On system BETA (the Connector/ODBC client), follow these steps:
1. Configure a Connector/ODBC DSN using parameters that match the server, database and
authentication information that you have just configured on system ALPHA.
Parameter
Value
Comment
DSN
remote_test
A name to identify the connection.
SERVER
ALPHA
The address of the remote server.
DATABASE
test
The name of the default database.
USER
myuser
The user name configured for access to this database.
PASSWORD mypassword
The password for
myuser
.
2. Using an ODBC-capable application, such as Microsoft Office, connect to the MySQL server using
the DSN you have just created. If the connection fails, use tracing to examine the connection
process. See
Section 20.1.4.8, “Getting an ODBC Trace File”
, for more information.
20.1.5.3. Connector/ODBC and Third-Party ODBC Tools
Once you have configured your Connector/ODBC DSN, you can access your MySQL database through
any application that supports the ODBC interface, including programming languages and third-party
applications. This section contains guides and help on using Connector/ODBC with various ODBC-
compatible tools and applications, including Microsoft Word, Microsoft Excel and Adobe/Macromedia
ColdFusion.
Connector/ODBC has been tested with the following applications:
Publisher
Application
Notes
Adobe
ColdFusion
Formerly Macromedia ColdFusion
Borland
C++ Builder
Builder 4
Delphi
Business Objects
Crystal Reports
Claris
Filemaker Pro
Содержание 5.0
Страница 1: ...MySQL 5 0 Reference Manual ...
Страница 18: ...xviii ...
Страница 60: ...40 ...
Страница 396: ...376 ...
Страница 578: ...558 ...
Страница 636: ...616 ...
Страница 844: ...824 ...
Страница 1234: ...1214 ...
Страница 1426: ...MySQL Proxy Scripting 1406 The following diagram shows an overview of the classes exposed by MySQL Proxy ...
Страница 1427: ...MySQL Proxy Scripting 1407 ...
Страница 1734: ...1714 ...
Страница 1752: ...1732 ...
Страница 1783: ...Configuring Connector ODBC 1763 ...
Страница 1793: ...Connector ODBC Examples 1773 ...
Страница 1839: ...Connector Net Installation 1819 2 You must choose the type of installation to perform ...
Страница 1842: ...Connector Net Installation 1822 5 Once the installation has been completed click Finish to exit the installer ...
Страница 1864: ...Connector Net Visual Studio Integration 1844 Figure 20 24 Debug Stepping Figure 20 25 Function Stepping 1 of 2 ...
Страница 2850: ...2830 ...
Страница 2854: ...2834 ...
Страница 2928: ...2908 ...
Страница 3000: ...2980 ...
Страница 3122: ...3102 ...
Страница 3126: ...3106 ...
Страница 3174: ...3154 ...
Страница 3232: ...3212 ...