Did you run the mytest\testfunc.pl? Thanks,
Jeff > -----Original Message----- > From: Charles E. Robinson III [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 10:48 AM > To: Jeff Urlwin > Cc: [EMAIL PROTECTED] > Subject: RE: DBD Issue > > > Thanks, for the response Jeff, its very much appreciated. I > posted it on the > wrong list. Thanks, again. > > > This is a solaris 8 server attempting to connect to a Solaris 8 progress > server. > > here's my main env settings: > UDBCINI=/usr/openlink/bin/udbc.ini > ODBCHOME=/usr/openlink/odbcsdk > $ODBCHOME=/usr/openlink/odbcsdk > ODBCINI=/usr/openlink/bin/odbc.ini > ODBCINSTINI=/usr/openlink/bin/odbcinst.ini > CLASSPATH=/usr/openlink/jdk1.2/opljdbc2.jar > LD_LIBRARY_PATH=/usr/openlink/lib > LIBPATH=/usr/openlink/lib > DBI_DSN=dbi:ODBC:alles9 > DBI_USER= > DBI_PASS= > SHLIB_PATH=/usr/openlink/lib > ~~~~~~~~~~~~~~~~ > here's the output from the test verbose: > livepes# make test TEST_VERBOSE=1 > PERL_DL_NONLAZY=1 > /usr/bin/perl -Iblib/arch -Iblib/lib > -I/usr/local/lib/perl5/5.6.1/sun4-solar > is -I/usr/local/lib/perl5/5.6.1 -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 > ok 2 > Test 3: create test table > Unable to find a suitable test type for field COL_C at t/ODBCTEST.pm line > 63. > dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 3-17 > Failed 15/17 tests, 11.76% okay > t/03dbatt...........1..6 > ok 1 > ok 2 > DBD::ODBC::db do failed: [OpenLink][ODBC][Progress Server]** Table > PERL_DBD_TEST does not exist or cannot be accessed. (962) (SQL-42S02)(DBD: > Execute immediate failed err=-1) at t/03dbatt.t line 60. > Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 19. > Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 20. > not ok 3 > ok 4 > DBD::ODBC::db do failed: [OpenLink][ODBC][Progress Server]** Table > PERL_DBD_TEST does not exist or cannot be accessed. (962) (SQL-42S02)(DBD: > Execute immediate failed err=-1) at t/03dbatt.t line 60. > Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 28. > Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 29. > ok 5 > ok 6 > FAILED test 3 > Failed 1/6 tests, 83.33% okay > t/05meth............1..6 > ok 1 > ok 2 > DBD::ODBC::db prepare failed: [OpenLink][ODBC][Progress Server]** Table > PERL_DBD_TEST does not exist or cannot be accessed. (962) (SQL-42S02)(DBD: > st_prepare/SQLPrepare err=-1) at t/05meth.t line 21. > Can't call method "execute" on an undefined value at t/05meth.t line 22. > Issuing rollback() for database handle being DESTROY'd without explicit > disconnect(). > dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 3-6 > Failed 4/6 tests, 33.33% okay > t/07bind............1..9 > ok 1 > Test 2: connecting to the database > ok 2 > Test 3: create test table > Unable to find a suitable test type for field COL_C at t/ODBCTEST.pm line > 63. > dubious > Test returned status 255 (wstat 65280, 0xff00) > DIED. FAILED tests 3-9 > Failed 7/9 tests, 22.22% okay > t/08bind2...........1..3 > Test 1: insert various test data, without having this test tell > the driver > the type > that is being bound to a column. This tests the use of > SQLDescribeParam to obtain > the column type on the insert. This is experimental > and will most > likely fail. > [OpenLink][ODBC][Progress Server]** Table PERL_DBD_TEST does not exist or > cannot be accessed. (962) (SQL-42S02)(DBD: st_prepare/SQLPrepare > err=-1) at > t/ODBCTEST.pm line 172. > These are tests which rely upon the driver to tell what the parameter type > is for the column. This means you need to ensure you tell your driver the > type of the column in bind_col(). > not ok 1 > [OpenLink][ODBC][Progress Server]** Table PERL_DBD_TEST does not exist or > cannot be accessed. (962) (SQL-42S02)(DBD: st_prepare/SQLPrepare > err=-1) at > t/ODBCTEST.pm line 172. > not ok 2 > [OpenLink][ODBC][Progress Server]** Table PERL_DBD_TEST does not exist or > cannot be accessed. (962) (SQL-42S02)(DBD: st_prepare/SQLPrepare > err=-1) at > t/ODBCTEST.pm line 172. > not ok 3 > FAILED tests 1-3 > Failed 3/3 tests, 0.00% okay > t/09multi...........1..0 > DBD::ODBC::db prepare failed: [OpenLink][ODBC][Progress Server]** > Unable to > understand after -- "PERL_DBD_TEST". (247) (SQL-S1000)(DBD: > st_prepare/SQLPrepare err=-1) at t/09multi.t line 38. > skipped test on this platform > Failed Test Status Wstat Total Fail Failed List of Failed > ------------------------------------------------------------------ > ---------- > ---- > t/02simple.t 255 65280 17 15 88.24% 3-17 > t/03dbatt.t 6 1 16.67% 3 > t/05meth.t 255 65280 6 4 66.67% 3-6 > t/07bind.t 255 65280 9 7 77.78% 3-9 > t/08bind2.t 3 3 100.00% 1-3 > 1 test skipped. > Failed 5/7 test scripts, 28.57% okay. 30/46 subtests failed, 34.78% okay. > *** Error code 29 > make: Fatal error: Command failed for target `test_dynamic' > ~~~~~~~~~~~~ > output from mytest/testfunc.pl: > install_driver(ODBC) failed: Can't locate DBD/ODBC.pm in @INC (@INC > contains: /usr/local/lib/perl5/5.6.1/sun4-solaris > /usr/local/lib/perl5/5.6.1 > /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris > /usr/local/lib/perl5/site_perl/5.6.1 /usr/local/lib/perl5/site_perl . ./t) > at (eval 1) line 3. > Perhaps the DBD::ODBC perl module hasn't been fully installed, > or perhaps the capitalisation of 'ODBC' isn't right. > Available drivers: ExampleP, Proxy. > at ./testfunc.pl line 9 > > > C.Robinson > > > -----Original Message----- > From: Jeff Urlwin [mailto:[EMAIL PROTECTED]] > Sent: Monday, April 01, 2002 9:14 PM > To: Charles E. Robinson III; [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: RE: DBD Issue > > > Charles, > > I haven't seen your post on dbi-users. That's where I usually support > things (as well as a number of other people. > > Anyway -- from what I can see, you are using Postgres via OpenLink's ODBC > bridge. I don't know much about postgres, directly, so if you > could run and > send me the output from the distribution file: mytest/testfunc.pl, that > would be helpful. Also, the output from make TEST_VERBOSE=1. > > Thanks, > > Jeff > > > > > > > As the author of the module I was hoping that you could shed > some light on > > an COL error I'm getting. > > I've sent the entire out but the last 20 lines are the errors. I would > > believe that since the COL > > field isn't being set properly the dbd test is failing. how could > > I correct > > this situation, I'd really appreciate it if you could point me in > > the right > > direction. Cause I've been unable to get any help on the posts. > > > > Thanks in advance. > > > > C.Robinson > > > > Output Below>> > > > > > > > > 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.6.1/sun4-solaris/au > > to/DBI > > Using ODBC in /usr/openlink/odbcsdk > > > > 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/openlink/odbcsdk/lib/libiodbc.a > > /usr/openlink/odbcsdk/lib/libiodbc.so l > > ibrary. > > > > Warning: LD_LIBRARY_PATH doesn't include /usr/openlink/odbcsdk/lib > > > > Checking if your kit is complete... > > Looks good > > Using DBI 1.21 installed in > > /usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/au > > to/DBI > > Writing Makefile for DBD::ODBC > > > > The DBD::ODBC tests will use these values for the database connection: > > DBI_DSN=dbi:ODBC:alles9 e.g. dbi:ODBC:demo > > DBI_USER= > > DBI_PASS= > > Warning: not all required environment variables are set. > > > > cp ODBC.pm blib/lib/DBD/ODBC.pm > > /usr/bin/perl -p -e "s/~DRIVER~/ODBC/g" < > > /usr/local/lib/perl5/site_perl/5.6.1/s > > un4-solaris/auto/DBI/Driver.xst > ODBC.xsi > > /usr/bin/perl -I/usr/local/lib/perl5/5.6.1/sun4-solaris > > -I/usr/local/lib/per > > l5/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 > > gcc -c -I. > > -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI -fno > > -str > > ict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE > > -D_FILE_OFFSET_BITS=64 > > -O > > -DVERSION=\"0.39\" -DXS_VERSION=\"0.39\" -fPIC > > -I/usr/local/lib/perl5/5. > > 6.1/ > > sun4-solaris/CORE -I/usr/openlink/odbcsdk/include ODBC.c > > gcc -c -I. > > -I/usr/local/lib/perl5/site_perl/5.6.1/sun4-solaris/auto/DBI -fno > > -str > > ict-aliasing -I/usr/local/include -D_LARGEFILE_SOURCE > > -D_FILE_OFFSET_BITS=64 > > -O > > -DVERSION=\"0.39\" -DXS_VERSION=\"0.39\" -fPIC > > -I/usr/local/lib/perl5/5. > > 6.1/ > > sun4-solaris/CORE -I/usr/openlink/odbcsdk/include dbdimp.c > > dbdimp.c:1644: warning: `_dbd_rebind_ph' was declared > implicitly `extern' > > and la > > ter `static' > > dbdimp.c:1190: 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/openlink/odbcsdk/lib" gcc -G -L/usr/local/lib ODBC.o > > dbdimp. > > o -o blib/arch/auto/DBD/ODBC/ODBC.so > > -L/usr/openlink/odbcsdk/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/ccs/bin/make -- OK > > Running make test > > PERL_DL_NONLAZY=1 > > /usr/bin/perl -Iblib/arch -Iblib/lib -I/usr/local/lib/perl5/5. > > 6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1 -e 'use Test::Harness > > qw(&runtests > > $verbose); $verbose=0; runtests @ARGV;' t/*.t > > t/01base............ok > > t/02simple..........ok 2/17Unable to find a suitable test type for field > > COL_C a > > t t/ODBCTEST.pm line 63. > > t/02simple..........dubious > > Test returned status 255 (wstat 65280, 0xff00) > > DIED. FAILED tests 3-17 > > Failed 15/17 tests, 11.76% okay > > t/03dbatt...........ok 2/6DBD::ODBC::db do failed: > > [OpenLink][ODBC][Progress > > Ser > > ver]** Table PERL_DBD_TEST does not exist or cannot be accessed. (962) > > (SQL-42S0 > > 2)(DBD: Execute immediate failed err=-1) at t/03dbatt.t line 60. > > Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 19. > > Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 20. > > t/03dbatt...........ok 4/6DBD::ODBC::db do failed: > > [OpenLink][ODBC][Progress > > Ser > > ver]** Table PERL_DBD_TEST does not exist or cannot be accessed. (962) > > (SQL-42S0 > > 2)(DBD: Execute immediate failed err=-1) at t/03dbatt.t line 60. > > Use of uninitialized value in numeric lt (<) at t/03dbatt.t line 28. > > Use of uninitialized value in numeric eq (==) at t/03dbatt.t line 29. > > t/03dbatt...........FAILED test 3 > > Failed 1/6 tests, 83.33% okay > > t/05meth............ok 2/6DBD::ODBC::db prepare failed: > > [OpenLink][ODBC][Progres > > s Server]** Table PERL_DBD_TEST does not exist or cannot be > > accessed. (962) > > (SQL > > -42S02)(DBD: st_prepare/SQLPrepare err=-1) at t/05meth.t line 21. > > Can't call method "execute" on an undefined value at t/05meth.t line 22. > > Issuing rollback() for database handle being DESTROY'd without explicit > > disconne > > ct(). > > t/05meth............dubious > > Test returned status 255 (wstat 65280, 0xff00) > > DIED. FAILED tests 3-6 > > Failed 4/6 tests, 33.33% okay > > t/07bind............ok 2/9Unable to find a suitable test type for field > > COL_C at > > t/ODBCTEST.pm line 63. > > t/07bind............dubious > > Test returned status 255 (wstat 65280, 0xff00) > > DIED. FAILED tests 3-9 > > Failed 7/9 tests, 22.22% okay > > t/08bind2...........[OpenLink][ODBC][Progress Server]** Table > > PERL_DBD_TEST > > does > > not exist or cannot be accessed. (962) (SQL-42S02)(DBD: > > st_prepare/SQLPrepare e > > rr=-1) at t/ODBCTEST.pm line 172. > > These are tests which rely upon the driver to tell what the > parameter type > > is fo > > r the column. This means you need to ensure you tell your > driver the type > > of th > > e column in bind_col(). > > t/08bind2...........NOK 1[OpenLink][ODBC][Progress Server]** Table > > PERL_DBD_TEST > > does not exist or cannot be accessed. (962) (SQL-42S02)(DBD: > > st_prepare/SQLPrep > > are err=-1) at t/ODBCTEST.pm line 172. > > t/08bind2...........NOK 2[OpenLink][ODBC][Progress Server]** Table > > PERL_DBD_TEST > > does not exist or cannot be accessed. (962) (SQL-42S02)(DBD: > > st_prepare/SQLPrep > > are err=-1) at t/ODBCTEST.pm line 172. > > t/08bind2...........FAILED tests 1-3 > > Failed 3/3 tests, 0.00% okay > > t/09multi...........skipped test on this platform > > Failed Test Status Wstat Total Fail Failed List of Failed > > ------------------------------------------------------------------ > > ---------- > > ---- > > t/02simple.t 255 65280 17 15 88.24% 3-17 > > t/03dbatt.t 6 1 16.67% 3 > > t/05meth.t 255 65280 6 4 66.67% 3-6 > > t/07bind.t 255 65280 9 7 77.78% 3-9 > > t/08bind2.t 3 3 100.00% 1-3 > > 1 test skipped. > > Failed 5/7 test scripts, 28.57% okay. 30/46 subtests failed, > 34.78% okay. > > *** Error code 29 > > make: Fatal error: Command failed for target `test_dynamic' > > /usr/ccs/bin/make test -- NOT OK > > Running make install > > make test had returned bad status, won't install without force > > > > > > >