List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:July 27 1999 12:41pm
Subject:iODBC
View as plain text  
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       |
+----------------------------------------------------------------------+
Thread
SV: Mysql-3_22_19b Install TroubleMartin Edelius18 Mar
  • iODBCsinisa27 Jul
    • Re: iODBCSanjeeb K Bhuyan27 Jul
  • Re: bug report: segfaults on large host,username,password,db fieldsMichael Widenius4 Nov
Re: SV: Mysql-3_22_19b Install TroubleKevin P. O'Brien18 Mar