MySQLTalk.org

Sanjeeb K Bhuyan · Guest

hi,

Thanx for all the help i've received..but nothing is easy when it
comes to odbc!!! so I finally try to configure myodbc,and it complains about
iodbc headers. So i decide to install iODBC,which I hadn't....I
download iODBC-2.50.22a from the mysql page,put it in a directory
called /export/home/..untar it,and then edit Config.mk as follows....
I set the ODBC_DIR to /export/home/tars/myodbc-2.50.24
Please note -- i installed iODBC in /export/home/

I changed MYSQL_DIR to /export/home/mysql-3.22.25
& MYSQL_DBLIBDIR to /export/home/mysql-3.22.25/client/.libs/mysql

now,in the Config.mk file it says to change MYSQL_DBLIBDIR to
MYSQL_DIR + lib/mysql,but I don't have a lib directory under
mysql-3.22.25 ..is that a problem?

i then uncommented the lines which referred to Solaris.
is there a configure fiel i have to run or something?

i then went to do a ...
make

and this is what i got....
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c dlf.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c dlproc.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c herr.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c henv.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c hdbc.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c hstmt.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c connect.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c prepare.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c execute.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c result.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c fetch.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c info.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c catalog.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -DFIX_INI_FILE -DDIR_
INI_FILE="/export/home/tars/myodbc-2.50.24/lib" -c misc.c
gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION="1.0.1" -c itrace.c
Generating iODBC driver manager --> /export/home/tars/myodbc-2.50.24/lib/iodbc.so

ld -G -L/export/home/tars/myodbc-2.50.24/lib dlf.o dlproc.o herr.o henv.o hdbc.o
hstmt.o connect.o prepare.o execute.o result.o fetch.o info.o catalog.o misc.o
itrace.o -o /export/home/tars/myodbc-2.50.24/lib/iodbc.so -ldl -lsocket -lnsl
ld: cannot open output file /export/home/tars/myodbc-2.50.24/lib/iodbc.so: No su
ch file or directory
make[1]: *** [/export/home/tars/myodbc-2.50.24/lib/iodbc.so] Error 1
make: *** [all] Error 2

It obviously isn't finding iodbc.so,right? well the funny thing
is off export/home/tars/myodbc-2.50.24 , there isn't a directory
called lib,nor is there a file iodbc.so anywhere on the system!!!!

well this was the error i was getting with myodbc 2.50.24---
checking for isql.h.........no
configure:error:Unable to find the iodbc headers in /usr/local/include

i copied isql.h and isqlext.h to
/usr/local/include ,and then ./configure works.....
when i try to do make,i get .....
/bin/sh ./libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I. -I. -I/export/home/
mysql-3.22.25/include -I/export/home/mysql-3.22.25 -I/usr/local/include -g -O2
-c catalog.c
gcc -DHAVE_CONFIG_H -I. -I. -I. -I/export/home/mysql-3.22.25/include -I/export/h
ome/mysql-3.22.25 -I/usr/local/include -g -O2 -Wp,-MD,.deps/catalog.pp -c -fPIC
-DPIC catalog.c -o catalog.lo
catalog.c: In function `SQLSpecialColumns':
catalog.c:449: `SQL_PC_NOT_PSEUDO' undeclared (first use in this function)
catalog.c:449: (Each undeclared identifier is reported only once
catalog.c:449: for each function it appears in.)
make: *** [catalog.lo] Error 1

whats going on!!i need help soon!!!!

one thing,i installed myODBC 2.50.24,and then i installed
iODBC,which comes with myODBC 2.50.22.....now which myo,should i be using?
i'm trying to configure myODBC 2.50.24.
i try to do a make with myODBC 2.50.22
and i get....

gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c catalog.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c connect.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c execute.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c info.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c myodbc.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c options.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c prepare.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c results.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c transact.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c utility.c
gcc -D_UNIX_ -O -fPIC -I/export/home/mysql-3.22.25/include -I/export/home/tars/myodbc-2.50.24/include -I/export/home/mysql-3.22.25 -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN -c dll.c
ar r /export/home/mysql-3.22.25/client/.libs/mysql/libmyodbc_mysql.a catalog.o connect.o execute.o info.o myodbc.o options.o prepare.o results.o transact.o utility.o dll.o
ar: /export/home/mysql-3.22.25/client/.libs/mysql/libmyodbc_mysql.a: No error
make: *** [lib] Error 1

please help me!
thanx,
sanjeeb

------- End of Forwarded Message