Introduction to MySQL database and its ODBC Interface (3) (reproduced)

mysql|odbc| Data | Database sender: Engineer (Jean ~ still have to go, sigh ...), letter area: Linux
Title: Introduction to MySQL Database and its ODBC Interface (3) (reprint)
Letter station: BBS Water Wood Tsinghua Station (Mon Aug 9 18:03:32 1999)

The following text is reproduced from the Database discussion area.
"The original was published by engineer."
Part II IODBC

I. IODBC INTRODUCTION

iODBC is a free MySQL library ODBC interface. Because of its short and short, widely circulated.

Two. IODBC Installation

1. Download from Ftp://166.111.68.178/linux/database
iodbc-2.12-3.src.rpm

!!! (Do not download iodbc-2.12-3.i386.rpm, the package has a problem with the ODBC
Tool Monitor,odbctool can be executed, but link iodbc.so write yourself
The program link error, if just use it tool can certainly, two times development
I can't.)

2. Use Rpm-ivh iodbc-2.12-3.src.rpm to unlock, generate files
/usr/src/redhat/sources/iodbc-2.50.11.tgz, find a catalogue.
Undo the Tar Zxvf/usr/src/redhat/sources/iodbc-2.50.11.tgz.
The proposal is placed under/usr/local and a directory IODBC is established.

3. To iodbc-src Normal compilation, you need to modify a lot of files, including
Iodbc/samples/makefile
Iodbc/myodbc-2.50.11/config.h
Iodbc/myodbc-2.50.11/m_string.h
Iodbc/myodbc-2.50.11/connect.c
For ease of use, I have changed the iODBC a bag, called
Iodbc-2.50.11-lg.tgz,:-) the right to be a free software person. Because the internet is inconvenient,
I haven't put it up yet, I'm sorry. Sorry

4. After installation iODBC under/USR/LIB/IODBC. The configuration file is Iodbc.ini.

Three. IODBC Preparation

In fact, the Iodbc.ini document has been very detailed, I said here more what is superfluous,

Then I'll say something about it.


One of the Iodbc.ini is set up in the SERVER, where the MySQL database is located

The name of the machine, both in iodbc-2.12-3.src.rpm and iodbc-2.12-3.i386.rpm.

Device: p, I see the internet as if it is purple. Then I changed some of the IODBC.

Some ODBC drivers, (//smile, really want to cheer for open source code!!!).
~~~~~~~~~~~~~~~~~~
Let it access the remote MySQL server. The details are temporarily confidential and you can actually look at the code to say.
Now it's okay to set [identify] and DSN in the Iodbc.ini file must be
In the same way, DB is the remote actual database name. As for the local machine, you don't have to set db.
The recommended remote DSN naming method is Databasename.hostname, which is:

Local: [Identify]//casual. hehe
DSN = DatabaseName
SERVER = localhost
...
Distal: [Databasename.hostname]
DSN = Databasename.hostname
SERVER = hostname
...

It's very simple. :-)