Sanjeeb K Bhuyan writes:
> Hi,
> My woes continue. This is what I have done so far.
> I installed the source package of mysql-3.22.25 in
> /export/home/minty/ directory. I followed the exact instructions in
> www.mysql.com/Manual_chapter/manual_Installing.html#Installing_source .
> It worked fine. Iused the post-installation steps to check that mysql
> was working fine. I was able to start mysql,create databases,etc.
> and use this MyODBC,right?
>
> Well the first thing to do is to edit Config.mk,and Config-solaris.mk.
> well both of them are pretty identical,so this is what i made
> Config.mk to look like....
>
> #============= Solaris =========================
> #
> CC = gcc
> PIC = -fPIC
> LDFLAGS = -G
> LIBS = -ldl -lsocket -lnsl
> MYSQL_LD = gcc
> #============ ODBC package ========================
> ODBC_DIR = /export/home/iodbc-2.50.22a/myodbc-2.50.22
> ODBC = iODBC
> iODBC = yes
> ODBC_INCLUDE = $(ODBC_DIR)/include
> ODBC_LIBPATH = $(ODBC_DIR)/lib
> ODBC_LIBS = $(ODBC_LIBPATH)/iodbc.so
> #============ Database settings ===================
> #
> NOW THE PROBLEMS BEGIN!
>
> i now attempt to do a "make",and this is what I get ....
>
> 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/iodbc-2.50.22a/myodbc-2.50.22/lib\" -c misc.c
> gcc -O -fPIC -I. -DDLDAPI_SVR4_DLFCN -DVERSION=\"1.0.1\" -c itrace.c
> Generating iODBC driver manager --> /export/home/iodbc-2.50.22a/myodbc-2.50.22/\
> lib/iodbc.so
> ld -G -L/export/home/iodbc-2.50.22a/myodbc-2.50.22/lib dlf.o dlproc.o herr.o he\
> nv.o hdbc.o hstmt.o connect.o prepare.o execute.o result.o fetch.o info.o catal\
> og.o misc.o itrace.o -o /export/home/iodbc-2.50.22a/myodbc-2.50.22/lib/iodbc.s\
> o -ldl -lsocket -lnsl
> if [ ! -f /export/home/iodbc-2.50.22a/myodbc-2.50.22/lib/iodbc.ini ]; then cp \
> iodbc.UNX /export/home/iodbc-2.50.22a/myodbc-2.50.22/lib/iodbc.ini; fi
> ar r /export/home/iodbc-2.50.22a/myodbc-2.50.22/lib/libiodbc.a dlf.o dlproc.o h\
> err.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
> ranlib /export/home/iodbc-2.50.22a/myodbc-2.50.22/lib/libiodbc.a
> cp isql.h /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/
> cp isqlext.h /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/
> cp odbc_types.h /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/
> cp odbc_funcs.h /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/
>
> %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
>
> Don't forget tu update /export/home/iodbc-2.50.22a/myodbc-2.50.22/lib/iodbc.ini\
> with your conf
>
> %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
>
> gcc -D_UNIX_ -O -fPIC -I/usr/local/mysql/include -I/export/home/iodbc-2.50.22\
> a/myodbc-2.50.22/include -I/usr/local/mysql -I../iODBC-2.12 -DDLDAPI_SVR4_DLFCN\
> -c catalog.c
> In file included from /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/global\
> .h:26,
> from myodbc.h:16,
> from catalog.c:9:
> /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/s-msdos.h:50: io.h: No such \
> file or directory
> In file included from /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/global\
> .h:26,
> from myodbc.h:16,
> from catalog.c:9:
> /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/s-msdos.h:88: warning: `F_UN\
> LCK' redefined
> /usr/include/sys/fcntl.h:257: warning: this is the location of the previous def\
> inition
> /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/s-msdos.h:89: warning: `F_WR\
> LCK' redefined
> /usr/include/sys/fcntl.h:256: warning: this is the location of the previous def\
> inition
> /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/s-msdos.h:90: warning: `F_RD\
> LCK' redefined
> /usr/include/sys/fcntl.h:255: warning: this is the location of the previous def\
> Buffers Files Tools Edit Search Help
> inition
> make[1]: *** [catalog.o] Error 1
> make: *** [all] Error 2
>
> So it looks like it is unable to find s-msdos.h,or there are problems with it.
> This file does exist in /export/home/iodbc-2.50.22a/myodbc-2.50.22/include/
> directory.
> There is also a mention fcntl.h which is in the /usr/include/sys/ directory.
> myodbc.h is in the /export/home/iodbc-2.50.22a/myodbc-2.50.22/ directory.
> catalog.c exists in /export/home/iodbc-2.50.22a/myodbc-2.50.22/ directory.
>
> Here's how my path looks -->
> /usr/local/bin:/export/home/iodbc-2.50.22a:/export/home/iodbc-2.50.22a/myodbc-2\
> .50.22:/export/home/iodbc-2.50.22a/myodbc-2.50.22/include:/export/home/iodbc-2.\
> 50.22a/myodbc-2.50.22/lib:/usr/sbin:/usr/bin:opt/Apple:/opt/Apple/Library/Execu\
> tables:/opt/Apple/Developer/Executables:/opt/Apple/Library/Receipts
>
> This has proven to be very frustrating. I have reinstalled various
> components many a time.
>
> One question--in the Config.mk file,when they say ODBC directory,
> what are they referring to?
> iodbc-2.50.22a
> myodbc-2.50.22
> iODBC-2.12
> ?????
> which one of them do I need? What is iODBC-2.12? It came along with
> iodbc-2.50.22a.tar.gz .... in Config.mk, ODBC was first equal to
> iODBC,and i changed it to myODBC.
>
> It doesn't work even if i try to set ODBC to iODBC-2.12...I just
> tried it to see what happens.
>
> I need help soon!
> thanx for all the help I have received,
> sanjeeb
>
Hi!
Sorry, have you installed iODBC, prior to installing MyODBC ??
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped|
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
