List:General Discussion« Previous MessageNext Message »
From:Sanjeeb K Bhuyan Date:July 26 1999 4:26pm
Subject:installing MyODBC problems....
View as plain text  
Hi,
  Basically I have a middleware package webobjects,and i have the
datbase mysl.and i want to communicate between the 2. Sice there
exists no native drivers,i understand that this has to go thru
ODBC..is this correct? and i'll need ODBC oin Solaris,since
both the middleware and databse are on solaris. So is the solution to install
myODBC? It seems from the mysql installation manuals that to install
myODBC i need either unixODBC or iODBC..is that correct?

So this is what I'm trying to do.....
I am trying to install and configure MyODBC 2.50.24 for Solaris 2.7.
Here's what I've done and here's a list of problems I have faced.

I tried to configure myODBC and it complained of iODBC header problems.
Realised that I have to install iODBC,so I downloaded iODBC-2.12.
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.
                   
The instructions say that I should do a "make"....but is there soemthing
I should do before then?
 
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!

                   the exact 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

            so i copied isql.h and isqlext.h to
/usr/local/include ,and then ./configure works fine.

But when I do a -- make
/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

            one thing,i installed myODBC 2.50.24,and then i installed
iODBC,which comes with myODBC 2.50.22..now which myodbc,should i be using?
i'm trying to configure myODBC 2.50.24.

just to see if I could compile the myODBC which comes with iODBC ,
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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_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_SV
R4_DLFCN    -c dll.c
ar r /export/home/mysql-3.22.25/client/.libs/mysql/libmyodbc_mysql.a catalog.o c
onnect.o execute.o info.o myodbc.o options.o prepare.o results.o transact.o util
ity.o dll.o
ar: /export/home/mysql-3.22.25/client/.libs/mysql/libmyodbc_mysql.a: No error
make: *** [lib] Error 1

              Any Ideas?

                          Thanks,
                            Sanjeeb




------- End of Forwarded Message

Thread
installing MyODBC problems....Sanjeeb K Bhuyan26 Jul