Jeff: I'm pretty sure I don't understand your first question.
I'm using libiodbc-2.50.3 which is part of the DBD-ODBC package. Where can I find a 3.x compatible version for FreeBSD? Will -----Original Message----- From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] Sent: Sunday, February 10, 2002 4:42 AM To: Will Spencer; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Undefined symbol "SQLFreeHandle" Will, What version of iODBC are you using? I suspect 2.x, not 3.x. Is it a problem to upgrade? The fix is simple. Instead of SQLFreeHandle, it should be SQLFreeStmt. I can fix that, but I would expect that a) I need to update the driver I distribute with DBD::ODBC (I had forgotten about it <G>) b) ODBC 3.0 features will be a future direction. Regards, Jeff > -----Original Message----- > From: Will Spencer [mailto:[EMAIL PROTECTED]] > Sent: Sunday, February 10, 2002 2:44 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Undefined symbol "SQLFreeHandle" > > > I am having difficulty installing the DBD::ODBC module. The trouble > seems to be related to an undefined symbol "SQLFreeHandle" > > I am attempting to install via CPAN: > > cpan> install DBD::ODBC > Going to read /root/.cpan/sources/authors/01mailrc.txt.gz > CPAN: Compress::Zlib loaded ok > Going to read /root/.cpan/sources/modules/02packages.details.txt.gz > Database was generated on Sat, 09 Feb 2002 23:41:20 GMT > CPAN: HTTP::Date loaded ok > Going to read /root/.cpan/sources/modules/03modlist.data.gz > Running install for module DBD::ODBC > Running make for J/JU/JURL/DBD-ODBC-0.35.tar.gz > CPAN: MD5 loaded ok > Checksum for > /root/.cpan/sources/authors/id/J/JU/JURL/DBD-ODBC-0.35.tar.gz ok > Scanning cache /root/.cpan/build for sizes > DBD-ODBC-0.35/ > DBD-ODBC-0.35/dbdimp.c > DBD-ODBC-0.35/dbdimp.h > DBD-ODBC-0.35/fixup_c.h > DBD-ODBC-0.35/fixup_t.h > DBD-ODBC-0.35/iodbcsrc/ > DBD-ODBC-0.35/iodbcsrc/libiodbc-2.50.3.tar.gz > DBD-ODBC-0.35/iodbcsrc/readme.txt > DBD-ODBC-0.35/Makefile.PL > DBD-ODBC-0.35/MANIFEST > DBD-ODBC-0.35/MANIFEST.SKIP > DBD-ODBC-0.35/mytest/ > DBD-ODBC-0.35/mytest/contest.pl > DBD-ODBC-0.35/mytest/listtabs.pl > DBD-ODBC-0.35/mytest/moreresults.pl > DBD-ODBC-0.35/mytest/testconn.pl > DBD-ODBC-0.35/mytest/testdatasources.pl > DBD-ODBC-0.35/mytest/testfunc.pl > DBD-ODBC-0.35/mytest/testigparams.pl > DBD-ODBC-0.35/mytest/testinout.pl > DBD-ODBC-0.35/mytest/testkeys.pl > DBD-ODBC-0.35/mytest/testmulti.pl > DBD-ODBC-0.35/mytest/testver.pl > DBD-ODBC-0.35/ODBC.h > DBD-ODBC-0.35/ODBC.pm > DBD-ODBC-0.35/ODBC.xs > DBD-ODBC-0.35/README > DBD-ODBC-0.35/README.adabas > DBD-ODBC-0.35/t/ > DBD-ODBC-0.35/t/01base.t > DBD-ODBC-0.35/t/02simple.t > DBD-ODBC-0.35/t/03dbatt.t > DBD-ODBC-0.35/t/05meth.t > DBD-ODBC-0.35/t/07bind.t > DBD-ODBC-0.35/t/08bind2.t > DBD-ODBC-0.35/t/09multi.t > DBD-ODBC-0.35/t/ODBCTEST.pm > Removing previously used /root/.cpan/build/DBD-ODBC-0.35 > > CPAN.pm: Going to build J/JU/JURL/DBD-ODBC-0.35.tar.gz > > > Configuring DBD::ODBC ... > > >>> Remember to actually *READ* the README file! > And re-read it if you have any problems. > > Using DBI 1.21 installed in > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI > Using ODBC in /usr/local > > Umm, this looks like a iodbc type of driver manager. > > We expect to find the isql.h, isqlext.h and iodbc.h files (which were > supplied with iODBC) in $ODBCHOME/include directory alongside > the /usr/local/lib/libiodbc.a /usr/local/lib/libiodbc.so library. > > > Checking if your kit is complete... > Looks good > Using DBI 1.21 installed in > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI > Writing Makefile for DBD::ODBC > > The DBD::ODBC tests will use these values for the database connection: > DBI_DSN=dbi:ODBC:database=onetoone;host=64.78.148.124;port=1071e.g. > dbi:ODBC:demo > DBI_USER=waterline2 > DBI_PASS=EPA123$ > > cp ODBC.pm blib/lib/DBD/ODBC.pm > /usr/local/bin/perl -p -e "s/~DRIVER~/ODBC/g" < > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI/Driver.xst > > ODBC.xsi > /usr/local/bin/perl -I/usr/local/lib/perl5/5.6.1/i386-freebsd > -I/usr/local/lib/perl5/5.6.1 /usr/local/lib/perl5/5.6.1/ExtUtils/xsubpp > -typemap /usr/local/lib/perl5/5.6.1/ExtUtils/typemap ODBC.xs > ODBC.xsc > && mv ODBC.xsc ODBC.c > cc -c -I. -I/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI > -fno-strict-aliasing -I/usr/local/include -O -DVERSION=\"0.35\" > -DXS_VERSION=\"0.35\" -DPIC -fpic > -I/usr/local/lib/perl5/5.6.1/i386-freebsd/CORE -I/usr/local/include > ODBC.c > cc -c -I. -I/usr/local/lib/perl5/site_perl/5.005/i386-freebsd/auto/DBI > -fno-strict-aliasing -I/usr/local/include -O -DVERSION=\"0.35\" > -DXS_VERSION=\"0.35\" -DPIC -fpic > -I/usr/local/lib/perl5/5.6.1/i386-freebsd/CORE -I/usr/local/include > dbdimp.c > dbdimp.c:1572: warning: `_dbd_rebind_ph' was declared implicitly > `extern' and later `static' > dbdimp.c:1121: warning: previous declaration of `_dbd_rebind_ph' > Running Mkbootstrap for DBD::ODBC () > chmod 644 ODBC.bs > rm -f blib/arch/auto/DBD/ODBC/ODBC.so > LD_RUN_PATH="/usr/local/lib" cc -shared -L/usr/local/lib ODBC.o > dbdimp.o -o blib/arch/auto/DBD/ODBC/ODBC.so -L/usr/local/lib -liodbc > chmod 755 blib/arch/auto/DBD/ODBC/ODBC.so > cp ODBC.bs blib/arch/auto/DBD/ODBC/ODBC.bs > chmod 644 blib/arch/auto/DBD/ODBC/ODBC.bs > Manifying blib/man3/DBD::ODBC.3 > /usr/bin/make -- OK > Running make test > PERL_DL_NONLAZY=1 /usr/local/bin/perl -Iblib/arch -Iblib/lib > -I/usr/local/lib/perl5/5.6.1/i386-freebsd -I/usr/local/lib/perl5/5.6.1 > -e 'use Test::Harness qw(&runtests $verbose); $verbose=0; runtests > @ARGV;' t/*.t > t/01base............install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/01base.t line 14 > t/01base............dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 4-5 > Failed 2/5 tests, 60.00% okay > t/02simple..........ok 1/17install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/02simple.t line 13 > t/02simple..........dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 2-17 > Failed 16/17 tests, 5.88% okay > t/03dbatt...........ok 1/6install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/03dbatt.t line 12 > t/03dbatt...........dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 2-6 > Failed 5/6 tests, 16.67% okay > t/05meth............ok 1/6install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/05meth.t line 13 > t/05meth............dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 2-6 > Failed 5/6 tests, 16.67% okay > t/07bind............ok 1/9install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/07bind.t line 11 > t/07bind............dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 2-9 > Failed 8/9 tests, 11.11% okay > t/08bind2...........install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/08bind2.t line 19 > t/08bind2...........dubious > Test returned status 255 (wstat 65280, 0xff00) > t/09multi...........install_driver(ODBC) failed: Can't load > 'blib/arch/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: > blib/arch/auto/DBD/ODBC/ODBC.so: Undefined symbol "SQLFreeHandle" at > /usr/local/lib/perl5/5.6.1/i386-freebsd/DynaLoader.pm line 206. > at (eval 1) line 3 > Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where expected > at t/09multi.t line 20 > t/09multi...........dubious > Test returned status 255 (wstat 65280, 0xff00) > Failed Test Status Wstat Total Fail Failed List of Failed > ------------------------------------------------------------------ > -------------- > > t/01base.t 255 65280 5 2 40.00% 4-5 > t/02simple.t 255 65280 17 16 94.12% 2-17 > t/03dbatt.t 255 65280 6 5 83.33% 2-6 > t/05meth.t 255 65280 6 5 83.33% 2-6 > t/07bind.t 255 65280 9 8 88.89% 2-9 > t/08bind2.t 255 65280 ?? ?? % ?? > t/09multi.t 255 65280 ?? ?? % ?? > Failed 7/7 test scripts, 0.00% okay. 36/43 subtests failed, 16.28% okay. > > *** Error code 2 > > Stop in /root/.cpan/build/DBD-ODBC-0.35. > /usr/bin/make test -- NOT OK > Running make install > make test had returned bad status, won't install without force > > > > My `perl -V` output is: > > www2# /usr/local/bin/perl -V > Summary of my perl5 (revision 5.0 version 6 subversion 1) configuration: > > Platform: > osname=freebsd, osvers=4.4-release, archname=i386-freebsd > uname='freebsd www2 4.4-release freebsd 4.4-release #0: tue sep 18 > 11:57:08 pdt 2001 [EMAIL PROTECTED]:usrsrcsyscompilegeneric > i386 ' > config_args='' > hint=recommended, useposix=true, d_sigaction=define > usethreads=undef use5005threads=undef useithreads=undef > usemultiplicity=undef > useperlio=undef d_sfio=undef uselargefiles=define usesocks=undef > use64bitint=undef use64bitall=undef uselongdouble=undef > Compiler: > cc='cc', ccflags ='-fno-strict-aliasing -I/usr/local/include', > optimize='-O', > cppflags='-fno-strict-aliasing -I/usr/local/include' > ccversion='', gccversion='2.95.3 20010315 (release) [FreeBSD]', > gccosandvers='' > intsize=4, longsize=4, ptrsize=4, doublesize=8, byteorder=1234 > d_longlong=define, longlongsize=8, d_longdbl=define, longdblsize=12 > ivtype='long', ivsize=4, nvtype='double', nvsize=8, Off_t='off_t', > lseeksize=8 > alignbytes=4, usemymalloc=n, prototype=define > Linker and Libraries: > ld='cc', ldflags ='-Wl,-E -L/usr/local/lib' > libpth=/usr/lib /usr/local/lib > libs=-lgdbm -ldb -lm -lc -lcrypt -liconv -lutil > perllibs=-lm -lc -lcrypt -liconv -lutil > libc=, so=so, useshrplib=false, libperl=libperl.a > Dynamic Linking: > dlsrc=dl_dlopen.xs, dlext=so, d_dlsymun=undef, ccdlflags=' ' > cccdlflags='-DPIC -fpic', lddlflags='-shared -L/usr/local/lib' > > > Characteristics of this binary (from libperl): > Compile-time options: USE_LARGE_FILES > Built under freebsd > Compiled at Feb 9 2002 18:59:57 > @INC: > /usr/local/lib/perl5/5.6.1/i386-freebsd > /usr/local/lib/perl5/5.6.1 > /usr/local/lib/perl5/site_perl/5.6.1/i386-freebsd > /usr/local/lib/perl5/site_perl/5.6.1 > /usr/local/lib/perl5/site_perl/5.005/i386-freebsd > /usr/local/lib/perl5/site_perl/5.005 > /usr/local/lib/perl5/site_perl > >
