Hi averyone..
I'm try to install the ODBC interface for use directly ASP + MySQL under
Linux..
I'm using Slackware 4.0 with kernel 2.2.6 + MySQL 3.22.25 + MyODBC 2.50.24
and unixODBC-Beta1.0.5.
That's what i did..
1) Compiled and installed the MySQL and all is working without errors.
2) Compiled and installed with standard options the unixODBC and all went
done without errors.
3) Compiled and installed the MyODBC driver with this options
./configure --with-mysql-sources=/usr/local/src/mysql-3.22.25
--with-unixODBC=/usr --with-unixODBC-libs=/usr/lib
--with-unixODBC-includes=/usr/include
and I installed the driver in /usr/local/lib (all without errors)
4) I have create a DSN entry in the file /etc/odbc.ini like this:
#----Begin of DSN=test lines----
[test]
Trace = On
TraceFile= stderr
Driver = /usr/local/lib/libmyodbc.so
DSN = testdsn
SERVER = localhost
USER = testlogin
PASSWORD = testpass
PORT = 3306
#OPTIONS = 1
DATABASE = testdatabase
SOCKET = /tmp/mysql.sock
#---End of DSN=test lines
5) I tested the connection using the ODBC to my database and bam...
# isql test testlogin testpass
[ISQL]ERROR: Could not SQLConnect
This is what the stderr file report to me ..
#cat stderr
[ODBC][20938][SQLConnect.c][170]Error: IM003
[ODBC][20938][SQLFreeHandle.c][123]
Entry:
Handle Type = 2
Input Handle = 0x804c4d8
I wanna specify that this kind of error isen't an authentification problem
because i have test to connect to database with the same infos via ODBC for
windows and all is working good.
Finally, after i readed the message posted here by Mr. Hood Gardner
(Subject: Re: [iHTML] Problem using unixODBC and MyODBC), i tested the
library compiled into this file
http://www.uni-koblenz.de/~horn/export/iodbc.tgz but i received a
Segmentation Fault error.
Right now i don't know how to fix this problem. I hope that someone around
have a solution for this problem.
Thanks in advice for any kind of idea or solution.
PS: I have try the same config under RedHat 6.0 and I got the same errors..
For do this kind of configuration i haven't used the ODBConfig interface.
--------------------------------------------------------
Simone Sestini
ATS-Link Communication
Network Admin
Via G. Ferraris, 216 - 52100 Arezzo
ITALY
E-Mail: mimmo@stripped
--------------------------------------------------------
