John, I believe iODBC has a test program to ensure your ODBC.ini is correct. That should be the major issue. iODBC includes the odbctest program in the samples directory.
I'm not sure what MySQL requires in the ODBC.ini, but I'd check that, too. Jeff > -----Original Message----- > From: John Ericson [mailto:[EMAIL PROTECTED]]On Behalf Of John > Ericson > Sent: Friday, February 15, 2002 8:39 PM > To: [EMAIL PROTECTED] > Subject: DBI:ODBC fails on test > > > When Im doing an 'make test' on DBI:ODBC it fails quite miserably. I have > got ODBC working with php so I know that my drivers and such is working. > > Versions: > Perl 5.6.0 > MySQL 3.23.46 > MyODBC 3.51.01 > iODBC 3.0.5 > DBI 1.21 > DBI:ODBC 0.38 > > iODBC is extraced to the directory /usr/local/libiodbc-3.0.5. It has > installed its lib files in /usr/local/lib and include files in > /usr/local/include. > > My /usr/local/include directory has these files (ls -F): > iodbcinst.h isqlext.h isql.h isqltypes.h php/ sqlext.h > sql.h sqltypes.h > > My /usr/local/lib has these files (ls -F): > libiodbc.a libiodbcinst.so.2.1.5* libmyodbc3-3.51.01.so* > libiodbcinst.a libiodbc.la* libmyodbc3.la* > libiodbcinst.la* libiodbc.so@ libmyodbc3.so@ > libiodbcinst.so@ libiodbc.so.2@ php/ > libiodbcinst.so.2@ libiodbc.so.2.1.5* php.ini > > DBI's 'make test' works out fine. > > When Im compiling DBI:ODBC I have these environments exported: > ODBCHOME="/usr/local" > LD_LIBRARY_PATH="/usr/local/lib" > LD_RUN_PATH="/usr/local/lib" > > DBI_DSN="dbi:ODBC:db" > DBI_USER="user" > DBI_PASS="pass" > ODBCINI="/etc/odbc.ini" > > When Im doing an 'perl Makefile.PL' everything seems fine and here is the > output: > 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/lib/perl5/site_perl/5.6.0/i386-linux/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 > /usr/local/lib/libiodbcinst.a /usr/local/lib/libiodbcinst.so library. > > > Using DBI 1.21 installed in > /usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI > Writing Makefile for DBD::ODBC > > The DBD::ODBC tests will use these values for the database connection: > DBI_DSN=dbi:ODBC:db e.g. dbi:ODBC:demo > DBI_USER=user > DBI_PASS=pass > > > When Im doing an 'make' I get this output: > gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI > -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 > -DVERSION=\"0.38\" -DXS_VERSION=\"0.38\" -fPIC > -I/usr/lib/perl5/5.6.0/i386-linux/CORE -I/usr/local/include ODBC.c > gcc -c -I. -I/usr/lib/perl5/site_perl/5.6.0/i386-linux/auto/DBI > -fno-strict-aliasing -O2 -march=i386 -mcpu=i686 > -DVERSION=\"0.38\" -DXS_VERSION=\"0.38\" -fPIC > -I/usr/lib/perl5/5.6.0/i386-linux/CORE -I/usr/local/include dbdimp.c > dbdimp.c:1586: warning: `_dbd_rebind_ph' was declared implicitly > `extern' and later `static' > dbdimp.c:1135: warning: previous declaration of `_dbd_rebind_ph' > Running Mkbootstrap for DBD::ODBC () > chmod 644 ODBC.bs > LD_RUN_PATH="/usr/local/lib" gcc -o > blib/arch/auto/DBD/ODBC/ODBC.so -shared -L/usr/local/lib ODBC.o > dbdimp.o -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.3pm > > Seems fine to me except a couple of warnings. Ill try with a 'make test > TEST_VERBOSE=1' and I get this: > PERL_DL_NONLAZY=1 /usr/bin/perl -Iblib/arch -Iblib/lib > -I/usr/lib/perl5/5.6.0/i386-linux -I/usr/lib/perl5/5.6.0 -e 'use > Test::Harness qw(&runtests $verbose); $verbose=1; runtests @ARGV;' t/*.t > t/01base............1..5 > ok 1 > ok 2 > ok 3 > ok 4 > ok 5 > ok > t/02simple..........1..17 > ok 1 > Test 2: connecting to the database > dubious > Test returned status 0 (wstat 15, 0xf) > DIED. FAILED tests 2-17 > Failed 16/17 tests, 5.88% okay > t/03dbatt...........1..6 > ok 1 > dubious > Test returned status 0 (wstat 15, 0xf) > DIED. FAILED tests 2-6 > Failed 5/6 tests, 16.67% okay > t/05meth............1..6 > ok 1 > dubious > Test returned status 0 (wstat 15, 0xf) > DIED. FAILED tests 2-6 > Failed 5/6 tests, 16.67% okay > t/07bind............1..9 > ok 1 > Test 2: connecting to the database > dubious > Test returned status 0 (wstat 15, 0xf) > DIED. FAILED tests 2-9 > Failed 8/9 tests, 11.11% okay > t/08bind2...........dubious > Test returned status 0 (wstat 15, 0xf) > t/09multi...........dubious > Test returned status 0 (wstat 15, 0xf) > Failed Test Status Wstat Total Fail Failed List of failed > ------------------------------------------------------------------ > ------------- > t/02simple.t 0 15 17 16 94.12% 2-17 > t/03dbatt.t 0 15 6 5 83.33% 2-6 > t/05meth.t 0 15 6 5 83.33% 2-6 > t/07bind.t 0 15 9 8 88.89% 2-9 > t/08bind2.t 0 15 ?? ?? % ?? > t/09multi.t 0 15 ?? ?? % ?? > Failed 6/7 test scripts, 14.29% okay. 34/43 subtests failed, 20.93% okay. > make: *** [test_dynamic] Error 2 > > > Please CC me since Im not a member of this maillinglist. > > -- > * John Ericson [EMAIL PROTECTED] > * ICQ: 7325429 JID: [EMAIL PROTECTED] > * web: http://john.pp.se >
