Dr A V Le Blanc
Guest
|
 Posted: Fri Jul 16, 1999 8:25 am Post subject: Re: ODBC access to MySQL on Linux |
 |
|
At 17:31 12/07/99 +0100, I wrote:
| Quote: | Description:
I have an urgent need to provide ODBC access to a database
running on a Unix system...
I am using Linux with glibc, mysql
version 3.22.24. I am trying to use myodbc-2.50.24 with
libiodbc-2.50.2.
|
On Tue, 13 Jul 1999 17:22:43 Colin McKinnon <colin (AT) wew (DOT) co.uk> wrote:
| Quote: | In most cases (including MySQL) you do not need to
add anything to a server correctly configured to run the DBMS (an exception
is Oracle which requires SQL*NET) in order to provide ODBC access - all you
need to do is install the ODBC driver on the client.
....
You're not wasting your time with MySQL - it does ODBC
You are wasting your time installing myodbc-2.50.24 & libiodbc-2.50.2. on
the server.
|
The whole mess is now working. Thanks to Colin's explanation, I installed
myodbc on the client machine, the one which is running Cold Fusion.
Having understood this, I found that:
(1) The permissions in the MySQL data base were not quite right, despite
having given a GRANT statement. I changed the required 'N' to 'Y'
by hand.
(2) I then got the client mysql to work on the machine on which Cold
Fusion is running.
(3) I next got a dumb ODBC client program to work (odbctest in the
libiodbc distribution). This required fixing some problems in
the odbc.ini file.
(4) I put links to the required shared libraries from the lib
directory /opt/coldfusion/lib, for the sake of simplicity.
(5) Finally, a note on someone's web site states that ColdFusion
will not connect to MySQL even if the odbc.ini file is correct,
unless the user name and password are set explicitly in the
ColdFusion administration tool.
It's now all working. For the curious, my entry in the odbc.ini file
on the Solaris system reads:
[birds]
Driver=/opt/coldfusion/lib/libmyodbc.so
Description=Museum Birds Data
DSN = birds
SERVER = <fully qualified domain name here>
DATABASE = birds
USER = <user name here>
PASSWORD = <password here>
PORT = 3306
I must say the people on various lists have been most helpful in
sorting this out, as were the participants in forums.allaire.com,
so thanks to you all.
-- Owen
[email]LeBlanc (AT) mcc (DOT) ac.uk[/email]
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
