Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options
 
PerlMonks  

Re^7: DBD::ODBC to Teradata

by DanEllison (Beadle)
on Mar 09, 2011 at 16:39 UTC ( #892230=note: print w/ replies, xml ) Need Help??


in reply to Re^6: DBD::ODBC to Teradata
in thread DBD::ODBC to Teradata

Okay, I'm back...

We've moved from the 32bit AIX environment to a 64bit Linux environment. I've followed my prescription from my previous troubles with no joy. DBD::ODBC compiles, but make test hangs in 05meth. If I install anyway and run, I get a Memory Fault.

When I compiled, there are plenty of warnings of unused variables and differing signedness which makes me uneasy.


Comment on Re^7: DBD::ODBC to Teradata
Re^8: DBD::ODBC to Teradata
by mje (Curate) on Mar 10, 2011 at 09:11 UTC

    I get no warnings compiling here on Linux with unixODBC header files. The compilation warnings can depend on what ODBC header files you use - not all ODBC driver managers are the same. Please post your ODBC driver manager name and the warnings.

    If it hangs in 05meth then do prove -vb t/05meth.t and post it. Even better, set DBI_TRACE=15=x.log and export it, then run prove and post the output. If you don't want to do that here then rt it and I'll look at it.

    However, I have not got Teradata and if you are using a commercial ODBC driver manager or ODBC driver I may only be able to offer limited help.

      Thanks for replying. Let me again note that I modified the Makefile.PL according to http://www.datadirect.com/resources/odbc/perl/config.html which was useful on 32bit AIX. I did keep a copy of the original Makefile.PL, and frankly I get the same result either way.

      delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> perl Makefile.PL PREFIX=${ +uwhdir}/${uwhenv}/public Argument "6.57_06" isn't numeric in subroutine entry at Makefile.PL li +ne 23 main::BEGIN() called at /etldata_daidev/dev1/public/lib/perl5/ +5.8.8/ExtUtils/MakeMaker.pm line 23 eval {...} called at /etldata_daidev/dev1/public/lib/perl5/5.8 +.8/ExtUtils/MakeMaker.pm line 23 Useless use of private variable in void context at Makefile.PL line 10 +24. ********** Remember to actually *READ* the README file! And re-read it if you have any problems. ********** OSNAME: linux LANG: en_US ODBCHOME: /opt/teradata/client/13.0/odbc_64 LD_LIBRARY_PATH: /usr/teragss/suselinux-x8664/client/lib:/opt/teradata +/client/13.0/odbc_64/lib:/opt/teradata/client/13.0/odbc_64/drivers:/o +pt/teradata/client/13.0/tbuild/lib:/usr/lib DBROOT: WINDIR: II_SYSTEM: You are using a Perl configured with threading enabled. Please read the warnings in DBI about this. You should also be aware that on non-Windows platforms ODBC drivers co +me in two forms, thread-safe and non-thread-safe drivers and you may need to make sure you are using the right one. Press return to continue... Looking for odbc_config at /opt/teradata/client/13.0/odbc_64/bin/odbc_ +config Looking for odbc_config on PATH odbc_config not found Looking for iodbc-config on PATH iodbc_config not found odbc_config not found - ok, there are other things I can do Still trying to guess ODBCHOME - looking for headers now trying /opt/teradata/client/13.0/odbc_64/include Found sql.h, sqlext.h, sqltypes.h in /opt/teradata/client/13.0/odbc_ +64/include Using ODBCHOME /opt/teradata/client/13.0/odbc_64 This looks like a intersolve type of driver manager. You seem to have the official header files. Multiple copies of Driver.xst found in: /etldata_daidev/dev1/public/li +b64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ /usr/li +b64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ at Ma +kefile.PL line 144 Using DBI 1.615 (for perl 5.008008 on x86_64-linux-thread-multi) insta +lled in /etldata_daidev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_6 +4-linux-thread-multi/auto/DBI/ Multiple copies of Driver.xst found in: /etldata_daidev/dev1/public/li +b64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ /usr/li +b64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi/auto/DBI/ at Ma +kefile.PL line 1035 Using DBI 1.615 (for perl 5.008008 on x86_64-linux-thread-multi) insta +lled in /etldata_daidev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_6 +4-linux-thread-multi/auto/DBI/ Writing Makefile for DBD::ODBC Writing MYMETA.yml The DBD::ODBC tests will use these values for the database connection: DBI_DSN=dbi:ODBC:udwdev e.g. dbi:ODBC:demo DBI_USER=delli28 DBI_PASS=XXXXXXXX
      delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> make Skip blib/lib/DBD/ODBC.pm (unchanged) gcc -c -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da +idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult +i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde +claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D +_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO +RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size +=4 -m64 -mtune=generic -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP +IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" Conver +tUTF.c gcc -c -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da +idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult +i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde +claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D +_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO +RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size +=4 -m64 -mtune=generic -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP +IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" ODBC.c ODBC.xsi: In function 'XS_DBD__ODBC__db__login': ODBC.xsi:96: warning: unused variable 'p' ODBC.xsi:95: warning: unused variable 'u' ODBC.xsi: In function 'XS_DBD__ODBC__st_bind_col': ODBC.xsi:497: warning: implicit declaration of function 'odbc_st_bind_ +col' ODBC.xs: In function 'XS_DBD__ODBC__st__statistics': ODBC.xs:99: warning: implicit declaration of function 'dbd_st_statisti +cs' ODBC.xs: In function 'XS_DBD__ODBC__db__ExecDirect': ODBC.xs:138: warning: unused variable 'lna' ODBC.xs: In function 'XS_DBD__ODBC__dr_data_sources': ODBC.xs:286: warning: pointer targets in passing argument 1 of '__buil +tin___strcpy_chk' differ in signedness ODBC.xs:286: warning: pointer targets in passing argument 1 of '__strc +py_ichk' differ in signedness ODBC.xs:306: warning: pointer targets in passing argument 2 of 'Perl_n +ewSVpv' differ in signedness gcc -c -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da +idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult +i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde +claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D +_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO +RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size +=4 -m64 -mtune=generic -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP +IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" dbdimp +.c dbdimp.c: In function 'odbc_db_login6': dbdimp.c:906: warning: pointer targets in passing argument 3 of 'SQLDr +iverConnect' differ in signedness dbdimp.c:906: warning: pointer targets in passing argument 5 of 'SQLDr +iverConnect' differ in signedness dbdimp.c:1009: warning: pointer targets in passing argument 2 of 'SQLC +onnect' differ in signedness dbdimp.c:1009: warning: pointer targets in passing argument 4 of 'SQLC +onnect' differ in signedness dbdimp.c:1009: warning: pointer targets in passing argument 6 of 'SQLC +onnect' differ in signedness dbdimp.c: In function 'dbd_error2': dbdimp.c:1238: warning: pointer targets in passing argument 2 of 'Perl +_newSVpv' differ in signedness dbdimp.c:1239: warning: pointer targets in passing argument 2 of 'Perl +_newSVpv' differ in signedness dbdimp.c:1260: warning: pointer targets in passing argument 1 of '__bu +iltin___strcat_chk' differ in signedness dbdimp.c:1260: warning: pointer targets in passing argument 1 of '__st +rcat_ichk' differ in signedness dbdimp.c:1261: warning: pointer targets in passing argument 1 of '__bu +iltin___strcat_chk' differ in signedness dbdimp.c:1261: warning: pointer targets in passing argument 2 of '__bu +iltin___strcat_chk' differ in signedness dbdimp.c:1261: warning: pointer targets in passing argument 1 of '__st +rcat_ichk' differ in signedness dbdimp.c:1261: warning: pointer targets in passing argument 2 of '__st +rcat_ichk' differ in signedness dbdimp.c:1262: warning: pointer targets in passing argument 1 of '__bu +iltin___strcat_chk' differ in signedness dbdimp.c:1262: warning: pointer targets in passing argument 1 of '__st +rcat_ichk' differ in signedness dbdimp.c:1266: warning: pointer targets in passing argument 1 of 'strl +en' differ in signedness dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu +iltin_strcmp' differ in signedness dbdimp.c:1266: warning: pointer targets in passing argument 1 of 'strl +en' differ in signedness dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu +iltin_strcmp' differ in signedness dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu +iltin_strcmp' differ in signedness dbdimp.c:1266: warning: pointer targets in passing argument 1 of '__bu +iltin_strcmp' differ in signedness dbdimp.c:1268: warning: pointer targets in passing argument 1 of '__bu +iltin___strcat_chk' differ in signedness dbdimp.c:1268: warning: pointer targets in passing argument 1 of '__st +rcat_ichk' differ in signedness dbdimp.c:1272: warning: pointer targets in passing argument 5 of 'imp_ +xxh->com.std.dbistate->set_err_char' differ in signedness dbdimp.c:1272: warning: pointer targets in passing argument 6 of 'imp_ +xxh->com.std.dbistate->set_err_char' differ in signedness dbdimp.c:1275: warning: pointer targets in passing argument 5 of 'imp_ +xxh->com.std.dbistate->set_err_char' differ in signedness dbdimp.c:1275: warning: pointer targets in passing argument 6 of 'imp_ +xxh->com.std.dbistate->set_err_char' differ in signedness dbdimp.c: In function 'dbd_preparse': dbdimp.c:1385: warning: unused variable 'param' dbdimp.c: In function 'odbc_st_tables': dbdimp.c:1575: warning: pointer targets in passing argument 2 of 'SQLT +ables' differ in signedness dbdimp.c:1575: warning: pointer targets in passing argument 4 of 'SQLT +ables' differ in signedness dbdimp.c:1575: warning: pointer targets in passing argument 6 of 'SQLT +ables' differ in signedness dbdimp.c:1575: warning: pointer targets in passing argument 8 of 'SQLT +ables' differ in signedness dbdimp.c: In function 'odbc_st_primary_keys': dbdimp.c:1637: warning: pointer targets in passing argument 2 of 'SQLP +rimaryKeys' differ in signedness dbdimp.c:1637: warning: pointer targets in passing argument 4 of 'SQLP +rimaryKeys' differ in signedness dbdimp.c:1637: warning: pointer targets in passing argument 6 of 'SQLP +rimaryKeys' differ in signedness dbdimp.c: In function 'dbd_st_statistics': dbdimp.c:1711: warning: pointer targets in passing argument 2 of 'SQLS +tatistics' differ in signedness dbdimp.c:1711: warning: pointer targets in passing argument 4 of 'SQLS +tatistics' differ in signedness dbdimp.c:1711: warning: pointer targets in passing argument 6 of 'SQLS +tatistics' differ in signedness dbdimp.c: In function 'odbc_st_prepare_sv': dbdimp.c:1881: warning: pointer targets in passing argument 2 of 'SQLP +repare' differ in signedness dbdimp.c: In function 'odbc_st_execute': dbdimp.c:2539: warning: pointer targets in passing argument 2 of 'SQLE +xecDirect' differ in signedness dbdimp.c:2592: warning: pointer targets in assignment differ in signed +ness dbdimp.c: In function 'rebind_param': dbdimp.c:3491: warning: pointer targets in assignment differ in signed +ness dbdimp.c:3497: warning: pointer targets in assignment differ in signed +ness dbdimp.c:3667: warning: suggest parentheses around && within || dbdimp.c: In function 'odbc_db_STORE_attrib': dbdimp.c:4088: warning: unused variable 'imp_drh' dbdimp.c: In function 'odbc_db_FETCH_attrib': dbdimp.c:4349: warning: unused variable 'imp_drh' dbdimp.c: In function 'odbc_st_FETCH_attrib': dbdimp.c:4639: warning: pointer targets in passing argument 2 of 'Perl +_newSVpv' differ in signedness dbdimp.c:4683: warning: pointer targets in passing argument 2 of 'SQLG +etCursorName' differ in signedness dbdimp.c: In function 'odbc_st_STORE_attrib': dbdimp.c:4806: warning: unused variable 'value' dbdimp.c:4802: warning: unused variable 'imp_dbh' dbdimp.c: In function 'odbc_get_special_columns': dbdimp.c:5037: warning: pointer targets in passing argument 3 of 'SQLS +pecialColumns' differ in signedness dbdimp.c:5037: warning: pointer targets in passing argument 5 of 'SQLS +pecialColumns' differ in signedness dbdimp.c:5037: warning: pointer targets in passing argument 7 of 'SQLS +pecialColumns' differ in signedness dbdimp.c: In function 'odbc_get_foreign_keys': dbdimp.c:5102: warning: pointer targets in passing argument 2 of 'SQLF +oreignKeys' differ in signedness dbdimp.c:5102: warning: pointer targets in passing argument 4 of 'SQLF +oreignKeys' differ in signedness dbdimp.c:5102: warning: pointer targets in passing argument 6 of 'SQLF +oreignKeys' differ in signedness dbdimp.c:5102: warning: pointer targets in passing argument 8 of 'SQLF +oreignKeys' differ in signedness dbdimp.c:5102: warning: pointer targets in passing argument 10 of 'SQL +ForeignKeys' differ in signedness dbdimp.c:5102: warning: pointer targets in passing argument 12 of 'SQL +ForeignKeys' differ in signedness dbdimp.c: In function 'odbc_describe_col': dbdimp.c:5129: warning: pointer targets in passing argument 3 of 'SQLD +escribeCol' differ in signedness dbdimp.c: In function 'odbc_col_attributes': dbdimp.c:5389: warning: pointer targets in passing argument 1 of 'strl +en' differ in signedness dbdimp.c:5389: warning: pointer targets in passing argument 2 of 'Perl +_newSVpv' differ in signedness dbdimp.c: In function 'odbc_db_columns': dbdimp.c:5473: warning: pointer targets in passing argument 2 of 'SQLC +olumns' differ in signedness dbdimp.c:5473: warning: pointer targets in passing argument 4 of 'SQLC +olumns' differ in signedness dbdimp.c:5473: warning: pointer targets in passing argument 6 of 'SQLC +olumns' differ in signedness dbdimp.c:5473: warning: pointer targets in passing argument 8 of 'SQLC +olumns' differ in signedness dbdimp.c: At top level: dbdimp.c:1989: warning: 'S_SqlCTypeToString' defined but not used dbdimp.c: In function 'odbc_st_lob_read': dbdimp.c:5222: warning: 'retlen' may be used uninitialized in this fun +ction gcc -c -I. -I/opt/teradata/client/13.0/odbc_64/include -I/etldata_da +idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult +i/auto/DBI -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -Wde +claration-after-statement -I/usr/local/include -D_LARGEFILE_SOURCE -D +_FILE_OFFSET_BITS=64 -I/usr/include/gdbm -O2 -g -pipe -Wall -Wp,-D_FO +RTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size +=4 -m64 -mtune=generic -DVERSION=\"1.25\" -DXS_VERSION=\"1.25\" -fP +IC "-I/usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/CORE" unicod +e_helper.c Running Mkbootstrap for DBD::ODBC () chmod 644 ODBC.bs rm -f blib/arch/auto/DBD/ODBC/ODBC.so LD_RUN_PATH="/opt/teradata/client/13.0/odbc_64/lib" gcc -shared -O2 - +g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector +--param=ssp-buffer-size=4 -m64 -mtune=generic ConvertUTF.o ODBC.o dbd +imp.o unicode_helper.o -o blib/arch/auto/DBD/ODBC/ODBC.so \ -L/opt/teradata/client/13.0/odbc_64/lib -R/opt/teradata/cli +ent/13.0/odbc_64/lib -lodbc \ gcc: unrecognized option '-R/opt/teradata/client/13.0/odbc_64/lib' 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
      delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> make test PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_h +arness(0, 'blib/lib', 'blib/arch')" t/*.t t/01base................ok t/02simple..............dubious Test returned status 0 (wstat 11, 0xb) DIED. FAILED tests 3-65 Failed 63/65 tests, 3.08% okay t/03dbatt...............dubious Test returned status 0 (wstat 11, 0xb) DIED. FAILED tests 3-29 Failed 27/29 tests, 6.90% okay t/05meth................ok 1/13make: *** [test_dynamic] Interrupt delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> export DBI_TRACE=15=x.log delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> prove -vb t/02simple.t t/02simple....1..65 0x2a00 DBI::db::get_info 0x10000 DBI::db::take_imp_data 0x10c00 DBI::db::disconnect 0x2000 DBI::db::selectrow_array 0x2200 DBI::db::tables 0x0430 DBI::db::quote_identifier 0x0000 DBI::db::clone 0x0430 DBI::db::quote 0x2200 DBI::db::type_info 0xaa00 DBI::db::statistics_info 0x2000 DBI::db::selectrow_arrayref 0x0400 DBI::db::begin_work 0x2800 DBI::db::last_insert_id 0xaa00 DBI::db::foreign_key_info 0x2200 DBI::db::primary_key 0x0c80 DBI::db::commit 0x0404 DBI::db::ping 0x2000 DBI::db::selectall_arrayref 0x2a00 DBI::db::type_info_all 0x3200 DBI::db::do 0x2000 DBI::db::selectcol_arrayref 0xa200 DBI::db::prepare_cached 0x0004 DBI::db::rows 0x0c80 DBI::db::rollback 0xaa00 DBI::db::column_info 0xaa00 DBI::db::table_info 0xaa00 DBI::db::primary_key_info 0xa200 DBI::db::prepare 0x0000 DBI::db::preparse 0x0004 DBI::db::connected 0x0200 DBI::db::data_sources 0x2000 DBI::db::selectall_hashref 0x2000 DBI::db::selectrow_hashref 0x0000 DBI::dr::default_user 0x0800 DBI::dr::data_sources 0x0004 DBI::dr::dbixs_revision 0x0800 DBI::dr::disconnect_all 0x8000 DBI::dr::connect_cached 0x8000 DBI::dr::connect 0x0000 DBI::st::more_results 0x0000 DBI::st::blob_read 0x0000 DBI::st::fetchall_hashref 0x0000 DBI::st::bind_param_inout_array 0x0000 DBI::st::finish 0x0004 DBI::st::rows 0x5040 DBI::st::execute_for_fetch 0x0000 DBI::st::fetchrow_hashref 0x0000 DBI::st::_get_fbav 0x0000 DBI::st::_set_fbav 0x0000 DBI::st::fetchrow 0x0000 DBI::st::fetch 0x5040 DBI::st::execute_array 0x0000 DBI::st::dump_results 0x0000 DBI::st::bind_param_array 0x0000 DBI::st::fetchrow_array 0x1040 DBI::st::execute 0x0000 DBI::st::bind_col 0x0000 DBI::st::fetchall_arrayref 0x0000 DBI::st::fetchrow_arrayref 0x0000 DBI::st::bind_param_inout 0x0000 DBI::st::bind_columns 0x0800 DBI::st::cancel 0x0000 DBI::st::blob_copy_to_file 0x0000 DBI::st::bind_param 0x0404 DBI::common::parse_trace_flag 0x0004 DBI::common::errstr 0x0004 DBI::common::trace_msg 0x0004 DBI::common::err 0x0004 DBI::common::CLEAR 0x0004 DBI::common::state 0x0000 DBI::common::_not_impl 0x0004 DBI::common::NEXTKEY 0x0004 DBI::common::trace 0x0004 DBI::common::debug 0x0404 DBI::common::parse_trace_flags 0x0000 DBI::common::private_attribute_info 0x0000 DBI::common::swap_inner_handle 0x0004 DBI::common::EXISTS 0x0404 DBI::common::visit_child_handles 0x0404 DBI::common::FETCH 0x0004 DBI::common::FIRSTKEY 0x0010 DBI::common::set_err 0x10004 DBI::common::DESTROY 0x0004 DBI::common::dump_handle 0x0404 DBI::common::FETCH_many 0x0100 DBI::common::can 0x041c DBI::common::STORE 0x0004 DBI::common::private_data 0x0006 DBI::common::func ok 1 - use DBI; ok 2 - use ODBCTEST; dubious Test returned status 0 (wstat 11, 0xb) DIED. FAILED tests 3-65 Failed 63/65 tests, 3.08% okay Failed Test Stat Wstat Total Fail Failed List of Failed ---------------------------------------------------------------------- +--------- t/02simple.t 0 11 65 126 193.85% 3-65 Failed 1/1 test scripts, 0.00% okay. 63/65 subtests failed, 3.08% okay +. delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> prove -vb t/05meth.t t/05meth....1..13 0x2a00 DBI::db::get_info 0x10000 DBI::db::take_imp_data 0x10c00 DBI::db::disconnect 0x2000 DBI::db::selectrow_array 0x2200 DBI::db::tables 0x0430 DBI::db::quote_identifier 0x0000 DBI::db::clone 0x0430 DBI::db::quote 0x2200 DBI::db::type_info 0xaa00 DBI::db::statistics_info 0x2000 DBI::db::selectrow_arrayref 0x0400 DBI::db::begin_work 0x2800 DBI::db::last_insert_id 0xaa00 DBI::db::foreign_key_info 0x2200 DBI::db::primary_key 0x0c80 DBI::db::commit 0x0404 DBI::db::ping 0x2000 DBI::db::selectall_arrayref 0x2a00 DBI::db::type_info_all 0x3200 DBI::db::do 0x2000 DBI::db::selectcol_arrayref 0xa200 DBI::db::prepare_cached 0x0004 DBI::db::rows 0x0c80 DBI::db::rollback 0xaa00 DBI::db::column_info 0xaa00 DBI::db::table_info 0xaa00 DBI::db::primary_key_info 0xa200 DBI::db::prepare 0x0000 DBI::db::preparse 0x0004 DBI::db::connected 0x0200 DBI::db::data_sources 0x2000 DBI::db::selectall_hashref 0x2000 DBI::db::selectrow_hashref 0x0000 DBI::dr::default_user 0x0800 DBI::dr::data_sources 0x0004 DBI::dr::dbixs_revision 0x0800 DBI::dr::disconnect_all 0x8000 DBI::dr::connect_cached 0x8000 DBI::dr::connect 0x0000 DBI::st::more_results 0x0000 DBI::st::blob_read 0x0000 DBI::st::fetchall_hashref 0x0000 DBI::st::bind_param_inout_array 0x0000 DBI::st::finish 0x0004 DBI::st::rows 0x5040 DBI::st::execute_for_fetch 0x0000 DBI::st::fetchrow_hashref 0x0000 DBI::st::_get_fbav 0x0000 DBI::st::_set_fbav 0x0000 DBI::st::fetchrow 0x0000 DBI::st::fetch 0x5040 DBI::st::execute_array 0x0000 DBI::st::dump_results 0x0000 DBI::st::bind_param_array 0x0000 DBI::st::fetchrow_array 0x1040 DBI::st::execute 0x0000 DBI::st::bind_col 0x0000 DBI::st::fetchall_arrayref 0x0000 DBI::st::fetchrow_arrayref 0x0000 DBI::st::bind_param_inout 0x0000 DBI::st::bind_columns 0x0800 DBI::st::cancel 0x0000 DBI::st::blob_copy_to_file 0x0000 DBI::st::bind_param 0x0404 DBI::common::parse_trace_flag 0x0004 DBI::common::errstr 0x0004 DBI::common::trace_msg 0x0004 DBI::common::err 0x0004 DBI::common::CLEAR 0x0004 DBI::common::state 0x0000 DBI::common::_not_impl 0x0004 DBI::common::NEXTKEY 0x0004 DBI::common::trace 0x0004 DBI::common::debug 0x0404 DBI::common::parse_trace_flags 0x0000 DBI::common::private_attribute_info 0x0000 DBI::common::swap_inner_handle 0x0004 DBI::common::EXISTS 0x0404 DBI::common::visit_child_handles 0x0404 DBI::common::FETCH 0x0004 DBI::common::FIRSTKEY 0x0010 DBI::common::set_err 0x10004 DBI::common::DESTROY 0x0004 DBI::common::dump_handle 0x0404 DBI::common::FETCH_many 0x0100 DBI::common::can 0x041c DBI::common::STORE 0x0004 DBI::common::private_data 0x0006 DBI::common::func ok 1 - use DBI;

        x.log:

        delli28@etllt0000:/u/delli28/DBD-ODBC-1.25> cat x.log DBI 1.615-ithread default trace level set to 0x0/15 (pid 29986 pi +177ec010) at DBI.pm line 278 via (eval 5) line 2 install_method DBI::db::get_info , flags 0x2a00, usage: min 2, max 2, '$info_type' install_method DBI::db::take_imp_data, flags 0x10000, usage: min 1, max 1, '' install_method DBI::db::disconnect , flags 0x10c00, usage: min 1, max 1, '' install_method DBI::db::selectrow_array, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::tables , flags 0x2200, usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ] +' install_method DBI::db::quote_identifier, flags 0x0430, usage: min 2, max 6, '$name [, ...] [, \%attr ]' install_method DBI::db::clone , usage: min 1, max 2, '[\%attr]' install_method DBI::db::quote , flags 0x0430, usage: min 2, max 3, '$string [, $data_type ]' install_method DBI::db::type_info , flags 0x2200, usage: min 1, max 2, '$data_type' install_method DBI::db::statistics_info, flags 0xaa00, usage: min 6, max 7, '$catalog, $schema, $table, $unique_only, $qu +ick, [, \%attr ]' install_method DBI::db::selectrow_arrayref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::begin_work , flags 0x0400, usage: min 1, max 2, '[ \%attr ]' install_method DBI::db::last_insert_id, flags 0x2800, usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name +[, \%attr ]' install_method DBI::db::foreign_key_info, flags 0xaa00, usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table, $fk_cata +log, $fk_schema, $fk_table [, \%attr ]' install_method DBI::db::primary_key , flags 0x2200, usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]' install_method DBI::db::commit , flags 0x0c80, usage: min 1, max 1, '' install_method DBI::db::ping , flags 0x0404, usage: min 1, max 1, '' install_method DBI::db::selectall_arrayref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::type_info_all, flags 0x2a00, usage: min 1, max 1, '' install_method DBI::db::do , flags 0x3200, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::selectcol_arrayref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::prepare_cached, flags 0xa200, usage: min 2, max 4, '$statement [, \%attr [, $if_active ] ]' install_method DBI::db::rows , flags 0x0004 install_method DBI::db::rollback , flags 0x0c80, usage: min 1, max 1, '' install_method DBI::db::column_info , flags 0xaa00, usage: min 5, max 6, '$catalog, $schema, $table, $column [, \%attr + ]' install_method DBI::db::table_info , flags 0xaa00, usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ] +' install_method DBI::db::primary_key_info, flags 0xaa00, usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]' install_method DBI::db::prepare , flags 0xa200, usage: min 2, max 3, '$statement [, \%attr]' install_method DBI::db::preparse install_method DBI::db::connected , flags 0x0004, usage: min 1, max 0, '' install_method DBI::db::data_sources, flags 0x0200, usage: min 1, max 2, '[\%attr]' install_method DBI::db::selectall_hashref, flags 0x2000, usage: min 3, max 0, '$statement, $keyfield [, \%attr [, @bind_par +ams ] ]' install_method DBI::db::selectrow_hashref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::dr::default_user, usage: min 3, max 4, '$user, $pass [, \%attr]' install_method DBI::dr::data_sources, flags 0x0800, usage: min 1, max 2, '[\%attr]' install_method DBI::dr::dbixs_revision, flags 0x0004 install_method DBI::dr::disconnect_all, flags 0x0800, usage: min 1, max 1, '' install_method DBI::dr::connect_cached, flags 0x8000, H 3, usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]' install_method DBI::dr::connect , flags 0x8000, H 3, usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]' install_method DBI::st::more_results, usage: min 1, max 1, '' install_method DBI::st::blob_read , usage: min 4, max 5, '$field, $offset, $len [, \$buf [, $bufoffset +]]' install_method DBI::st::fetchall_hashref, usage: min 2, max 2, '$key_field' install_method DBI::st::bind_param_inout_array, usage: min 4, max 5, '$parameter, \@var, $maxlen, [, \%attr]' install_method DBI::st::finish , usage: min 1, max 1, '' install_method DBI::st::rows , flags 0x0004 install_method DBI::st::execute_for_fetch, flags 0x5040, usage: min 2, max 3, '$fetch_sub [, $tuple_status]' install_method DBI::st::fetchrow_hashref install_method DBI::st::_get_fbav install_method DBI::st::_set_fbav , T 6 install_method DBI::st::fetchrow install_method DBI::st::fetch install_method DBI::st::execute_array, flags 0x5040, usage: min 2, max 0, '\%attribs [, @args]' install_method DBI::st::dump_results, usage: min 1, max 5, '$maxfieldlen, $linesep, $fieldsep, $filehand +le' install_method DBI::st::bind_param_array, usage: min 3, max 4, '$parameter, $var [, \%attr]' install_method DBI::st::fetchrow_array install_method DBI::st::execute , flags 0x1040, usage: min 1, max 0, '[@args]' install_method DBI::st::bind_col , usage: min 3, max 4, '$column, \$var [, \%attr]' install_method DBI::st::fetchall_arrayref, usage: min 1, max 3, '[ $slice [, $max_rows]]' install_method DBI::st::fetchrow_arrayref install_method DBI::st::bind_param_inout, usage: min 4, max 5, '$parameter, \$var, $maxlen, [, \%attr]' install_method DBI::st::bind_columns, usage: min 2, max 0, '\$var1 [, \$var2, ...]' install_method DBI::st::cancel , flags 0x0800, usage: min 1, max 1, '' install_method DBI::st::blob_copy_to_file, usage: min 3, max 3, '$field, $filename_or_handleref' install_method DBI::st::bind_param , usage: min 3, max 4, '$parameter, $var [, \%attr]' install_method DBI::common::parse_trace_flag, flags 0x0404, T 8, usage: min 2, max 2, '$name' install_method DBI::common::errstr , flags 0x0004 install_method DBI::common::trace_msg, flags 0x0004, T 8, usage: min 2, max 3, '$message_text [, $min_level ]' install_method DBI::common::err , flags 0x0004 install_method DBI::common::CLEAR , flags 0x0004 install_method DBI::common::state , flags 0x0004 install_method DBI::common::_not_impl install_method DBI::common::NEXTKEY , flags 0x0004 install_method DBI::common::trace , flags 0x0004, usage: min 1, max 3, '[$trace_level, [$filename]]' install_method DBI::common::debug , flags 0x0004, usage: min 1, max 2, '[$debug_level]' install_method DBI::common::parse_trace_flags, flags 0x0404, T 8, usage: min 2, max 2, '$flags' install_method DBI::common::private_attribute_info install_method DBI::common::swap_inner_handle, usage: min 2, max 3, '$h [, $allow_reparent ]' install_method DBI::common::EXISTS , flags 0x0004 install_method DBI::common::visit_child_handles, flags 0x0404, T 4, usage: min 2, max 3, '$coderef [, $info ]' install_method DBI::common::FETCH , flags 0x0404 install_method DBI::common::FIRSTKEY, flags 0x0004 install_method DBI::common::set_err , flags 0x0010, usage: min 3, max 6, '$err, $errmsg [, $state, $method, $rv]' install_method DBI::common::DESTROY , flags 0x10004 install_method DBI::common::dump_handle, flags 0x0004, usage: min 1, max 3, '[$message [, $level]]' install_method DBI::common::FETCH_many, flags 0x0404 install_method DBI::common::can , flags 0x0100 install_method DBI::common::STORE , flags 0x041c install_method DBI::common::private_data, flags 0x0004, usage: min 1, max 1, '' install_method DBI::common::func , flags 0x0006 -> DBI->connect(, , ****) -> DBI->install_driver(ODBC) for linux perl=5.008008 pid=29986 rui +d=43679 euid=43679 install_driver: DBD::ODBC version 1.25 loaded from blib/lib/DBD +/ODBC.pm New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x17bfaf00)=>DBI::dr=HASH(0x17bfaf7 +0), DBD::ODBC::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::ODBC::dr, 168, 0) thr#177ec010 dbih_setup_attrib(DBI::dr=HASH(0x17bfaf70), Err, Null!) SCALAR(0x1 +797e240) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x17bfaf70), State, Null!) SCALAR(0 +x1797d8f0) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x17bfaf70), Errstr, Null!) SCALAR( +0x1797d9d0) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x17bfaf70), TraceLevel, Null!) 0 ( +already defined) dbih_setup_attrib(DBI::dr=HASH(0x17bfaf70), FetchHashKeyName, Null +!) 'NAME' (already defined) install_method DBI::st::odbc_lob_read <- install_driver= DBI::dr=HASH(0x17bfaf00) >> default_user DISPATCH (DBI::dr=HASH(0x17bfaf00) rc1/3 @4 g1 ima +1 pid#29986) at /etldata_daidev/dev1/public/lib64/perl5/site_perl/5.8 +.8/x86_64-linux-thread-multi/DBI.pm line 653 via at t/02simple.t lin +e 33 !! warn: 0 CLEARED by call to default_user method -> default_user in DBD::_::dr for DBD::ODBC::dr (DBI::dr=HASH(0x17 +bfaf00)~0x17bfaf70 undef undef HASH(0x17a66c60)) thr#177ec010 <- default_user= ( 'delli28' 'XXXXXXXX' ) [2 items] at /etldata_da +idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult +i/DBI.pm line 653 via at t/02simple.t line 33 >> connect DISPATCH (DBI::dr=HASH(0x17bfaf00) rc2/3 @5 g0 ima8 +001 pid#29986) at /etldata_daidev/dev1/public/lib64/perl5/site_perl/5 +.8.8/x86_64-linux-thread-multi/DBI.pm line 665 -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x17bfaf00)~0x17bfaf70 +'udwdev' 'delli28' **** HASH(0x17a66c60)) thr#177ec010 New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x17bfaf70), + id=undef) dbih_setup_handle(DBI::db=HASH(0x17bfb560)=>DBI::db=HASH(0x17bfb4b +0), DBD::ODBC::db, 17acb190, Null!) dbih_make_com(DBI::dr=HASH(0x17bfaf70), 17b9e5c0, DBD::ODBC::db, 5 +60, 0) thr#177ec010 dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), Err, DBI::dr=HASH(0x17 +bfaf70)) SCALAR(0x17acb3a0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), State, DBI::dr=HASH(0x +17bfaf70)) SCALAR(0x17acb420) (already defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), Errstr, DBI::dr=HASH(0 +x17bfaf70)) SCALAR(0x17acb3e0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), TraceLevel, DBI::dr=HA +SH(0x17bfaf70)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), FetchHashKeyName, DBI: +:dr=HASH(0x17bfaf70)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), HandleSetErr, DBI::dr= +HASH(0x17bfaf70)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), HandleError, DBI::dr=H +ASH(0x17bfaf70)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), ReadOnly, DBI::dr=HASH +(0x17bfaf70)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x17bfb4b0), Profile, DBI::dr=HASH( +0x17bfaf70)) undef (not defined) !!dbd_error2(err_rc=0, what=db_login/SQLAllocHandle(env), handles= +(0,0,0) DBI 1.615-ithread default trace level set to 0x0/15 (pid 31996 pi +165e2010) at DBI.pm line 278 via (eval 5) line 2 install_method DBI::db::get_info , flags 0x2a00, usage: min 2, max 2, '$info_type' install_method DBI::db::take_imp_data, flags 0x10000, usage: min 1, max 1, '' install_method DBI::db::disconnect , flags 0x10c00, usage: min 1, max 1, '' install_method DBI::db::selectrow_array, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::tables , flags 0x2200, usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ] +' install_method DBI::db::quote_identifier, flags 0x0430, usage: min 2, max 6, '$name [, ...] [, \%attr ]' install_method DBI::db::clone , usage: min 1, max 2, '[\%attr]' install_method DBI::db::quote , flags 0x0430, usage: min 2, max 3, '$string [, $data_type ]' install_method DBI::db::type_info , flags 0x2200, usage: min 1, max 2, '$data_type' install_method DBI::db::statistics_info, flags 0xaa00, usage: min 6, max 7, '$catalog, $schema, $table, $unique_only, $qu +ick, [, \%attr ]' install_method DBI::db::selectrow_arrayref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::begin_work , flags 0x0400, usage: min 1, max 2, '[ \%attr ]' install_method DBI::db::last_insert_id, flags 0x2800, usage: min 5, max 6, '$catalog, $schema, $table_name, $field_name +[, \%attr ]' install_method DBI::db::foreign_key_info, flags 0xaa00, usage: min 7, max 8, '$pk_catalog, $pk_schema, $pk_table, $fk_cata +log, $fk_schema, $fk_table [, \%attr ]' install_method DBI::db::primary_key , flags 0x2200, usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]' install_method DBI::db::commit , flags 0x0c80, usage: min 1, max 1, '' install_method DBI::db::ping , flags 0x0404, usage: min 1, max 1, '' install_method DBI::db::selectall_arrayref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::type_info_all, flags 0x2a00, usage: min 1, max 1, '' install_method DBI::db::do , flags 0x3200, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::selectcol_arrayref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::db::prepare_cached, flags 0xa200, usage: min 2, max 4, '$statement [, \%attr [, $if_active ] ]' install_method DBI::db::rows , flags 0x0004 install_method DBI::db::rollback , flags 0x0c80, usage: min 1, max 1, '' install_method DBI::db::column_info , flags 0xaa00, usage: min 5, max 6, '$catalog, $schema, $table, $column [, \%attr + ]' install_method DBI::db::table_info , flags 0xaa00, usage: min 1, max 6, '$catalog, $schema, $table, $type [, \%attr ] +' install_method DBI::db::primary_key_info, flags 0xaa00, usage: min 4, max 5, '$catalog, $schema, $table [, \%attr ]' install_method DBI::db::prepare , flags 0xa200, usage: min 2, max 3, '$statement [, \%attr]' install_method DBI::db::preparse install_method DBI::db::connected , flags 0x0004, usage: min 1, max 0, '' install_method DBI::db::data_sources, flags 0x0200, usage: min 1, max 2, '[\%attr]' install_method DBI::db::selectall_hashref, flags 0x2000, usage: min 3, max 0, '$statement, $keyfield [, \%attr [, @bind_par +ams ] ]' install_method DBI::db::selectrow_hashref, flags 0x2000, usage: min 2, max 0, '$statement [, \%attr [, @bind_params ] ]' install_method DBI::dr::default_user, usage: min 3, max 4, '$user, $pass [, \%attr]' install_method DBI::dr::data_sources, flags 0x0800, usage: min 1, max 2, '[\%attr]' install_method DBI::dr::dbixs_revision, flags 0x0004 install_method DBI::dr::disconnect_all, flags 0x0800, usage: min 1, max 1, '' install_method DBI::dr::connect_cached, flags 0x8000, H 3, usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]' install_method DBI::dr::connect , flags 0x8000, H 3, usage: min 1, max 5, '[$db [,$user [,$passwd [,\%attr]]]]' install_method DBI::st::more_results, usage: min 1, max 1, '' install_method DBI::st::blob_read , usage: min 4, max 5, '$field, $offset, $len [, \$buf [, $bufoffset +]]' install_method DBI::st::fetchall_hashref, usage: min 2, max 2, '$key_field' install_method DBI::st::bind_param_inout_array, usage: min 4, max 5, '$parameter, \@var, $maxlen, [, \%attr]' install_method DBI::st::finish , usage: min 1, max 1, '' install_method DBI::st::rows , flags 0x0004 install_method DBI::st::execute_for_fetch, flags 0x5040, usage: min 2, max 3, '$fetch_sub [, $tuple_status]' install_method DBI::st::fetchrow_hashref install_method DBI::st::_get_fbav install_method DBI::st::_set_fbav , T 6 install_method DBI::st::fetchrow install_method DBI::st::fetch install_method DBI::st::execute_array, flags 0x5040, usage: min 2, max 0, '\%attribs [, @args]' install_method DBI::st::dump_results, usage: min 1, max 5, '$maxfieldlen, $linesep, $fieldsep, $filehand +le' install_method DBI::st::bind_param_array, usage: min 3, max 4, '$parameter, $var [, \%attr]' install_method DBI::st::fetchrow_array install_method DBI::st::execute , flags 0x1040, usage: min 1, max 0, '[@args]' install_method DBI::st::bind_col , usage: min 3, max 4, '$column, \$var [, \%attr]' install_method DBI::st::fetchall_arrayref, usage: min 1, max 3, '[ $slice [, $max_rows]]' install_method DBI::st::fetchrow_arrayref install_method DBI::st::bind_param_inout, usage: min 4, max 5, '$parameter, \$var, $maxlen, [, \%attr]' install_method DBI::st::bind_columns, usage: min 2, max 0, '\$var1 [, \$var2, ...]' install_method DBI::st::cancel , flags 0x0800, usage: min 1, max 1, '' install_method DBI::st::blob_copy_to_file, usage: min 3, max 3, '$field, $filename_or_handleref' install_method DBI::st::bind_param , usage: min 3, max 4, '$parameter, $var [, \%attr]' install_method DBI::common::parse_trace_flag, flags 0x0404, T 8, usage: min 2, max 2, '$name' install_method DBI::common::errstr , flags 0x0004 install_method DBI::common::trace_msg, flags 0x0004, T 8, usage: min 2, max 3, '$message_text [, $min_level ]' install_method DBI::common::err , flags 0x0004 install_method DBI::common::CLEAR , flags 0x0004 install_method DBI::common::state , flags 0x0004 install_method DBI::common::_not_impl install_method DBI::common::NEXTKEY , flags 0x0004 install_method DBI::common::trace , flags 0x0004, usage: min 1, max 3, '[$trace_level, [$filename]]' install_method DBI::common::debug , flags 0x0004, usage: min 1, max 2, '[$debug_level]' install_method DBI::common::parse_trace_flags, flags 0x0404, T 8, usage: min 2, max 2, '$flags' install_method DBI::common::private_attribute_info install_method DBI::common::swap_inner_handle, usage: min 2, max 3, '$h [, $allow_reparent ]' install_method DBI::common::EXISTS , flags 0x0004 install_method DBI::common::visit_child_handles, flags 0x0404, T 4, usage: min 2, max 3, '$coderef [, $info ]' install_method DBI::common::FETCH , flags 0x0404 install_method DBI::common::FIRSTKEY, flags 0x0004 install_method DBI::common::set_err , flags 0x0010, usage: min 3, max 6, '$err, $errmsg [, $state, $method, $rv]' install_method DBI::common::DESTROY , flags 0x10004 install_method DBI::common::dump_handle, flags 0x0004, usage: min 1, max 3, '[$message [, $level]]' install_method DBI::common::FETCH_many, flags 0x0404 install_method DBI::common::can , flags 0x0100 install_method DBI::common::STORE , flags 0x041c install_method DBI::common::private_data, flags 0x0004, usage: min 1, max 1, '' install_method DBI::common::func , flags 0x0006 -> DBI->connect(, , ****) -> DBI->install_driver(ODBC) for linux perl=5.008008 pid=31996 rui +d=43679 euid=43679 install_driver: DBD::ODBC version 1.25 loaded from blib/lib/DBD +/ODBC.pm New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x169b4a40)=>DBI::dr=HASH(0x169b4ab +0), DBD::ODBC::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::ODBC::dr, 168, 0) thr#165e2010 dbih_setup_attrib(DBI::dr=HASH(0x169b4ab0), Err, Null!) SCALAR(0x1 +6815530) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x169b4ab0), State, Null!) SCALAR(0 +x168154d0) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x169b4ab0), Errstr, Null!) SCALAR( +0x16815500) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x169b4ab0), TraceLevel, Null!) 0 ( +already defined) dbih_setup_attrib(DBI::dr=HASH(0x169b4ab0), FetchHashKeyName, Null +!) 'NAME' (already defined) install_method DBI::st::odbc_lob_read <- install_driver= DBI::dr=HASH(0x169b4a40) >> default_user DISPATCH (DBI::dr=HASH(0x169b4a40) rc1/3 @4 g1 ima +1 pid#31996) at /etldata_daidev/dev1/public/lib64/perl5/site_perl/5.8 +.8/x86_64-linux-thread-multi/DBI.pm line 653 via at t/05meth.t line +34 !! warn: 0 CLEARED by call to default_user method -> default_user in DBD::_::dr for DBD::ODBC::dr (DBI::dr=HASH(0x16 +9b4a40)~0x169b4ab0 undef undef HASH(0x16849920)) thr#165e2010 <- default_user= ( 'delli28' 'XXXXXXXX' ) [2 items] at /etldata_da +idev/dev1/public/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-mult +i/DBI.pm line 653 via at t/05meth.t line 34 >> connect DISPATCH (DBI::dr=HASH(0x169b4a40) rc2/3 @5 g0 ima8 +001 pid#31996) at /etldata_daidev/dev1/public/lib64/perl5/site_perl/5 +.8.8/x86_64-linux-thread-multi/DBI.pm line 665 -> connect for DBD::ODBC::dr (DBI::dr=HASH(0x169b4a40)~0x169b4ab0 +'udwdev' 'delli28' **** HASH(0x16849920)) thr#165e2010 New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x169b4ab0), + id=undef) dbih_setup_handle(DBI::db=HASH(0x169c0750)=>DBI::db=HASH(0x169c06a +0), DBD::ODBC::db, 168aed40, Null!) dbih_make_com(DBI::dr=HASH(0x169b4ab0), 169c0090, DBD::ODBC::db, 5 +60, 0) thr#165e2010 dbih_setup_attrib(DBI::db=HASH(0x169c06a0), Err, DBI::dr=HASH(0x16 +9b4ab0)) SCALAR(0x168aef50) (already defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), State, DBI::dr=HASH(0x +169b4ab0)) SCALAR(0x168aefd0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), Errstr, DBI::dr=HASH(0 +x169b4ab0)) SCALAR(0x168aef90) (already defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), TraceLevel, DBI::dr=HA +SH(0x169b4ab0)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), FetchHashKeyName, DBI: +:dr=HASH(0x169b4ab0)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), HandleSetErr, DBI::dr= +HASH(0x169b4ab0)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), HandleError, DBI::dr=H +ASH(0x169b4ab0)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), ReadOnly, DBI::dr=HASH +(0x169b4ab0)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x169c06a0), Profile, DBI::dr=HASH( +0x169b4ab0)) undef (not defined) !!dbd_error2(err_rc=0, what=db_login/SQLAllocHandle(env), handles= +(0,0,0)

        Thanks Dan.

        There is not a lot I can do about some of those warnings as they come from Perl internal macros. Anything in ODBC.xsi comes from DBI and not DBD::ODBC so all DBDs will have those warnings on your machine. I will attempt to sort some of them out where I can but I don't see anything there which you should worry about (people have been using DBI and DBD::ODBC for years with these warnings.

        It looks like the log files have been truncated - perhaps you could send them to me at mjevans@cpan.org.

        There is not a lot I can do about looking into DataDirect ODBC driver or ODBC driver manager issues (which you are using) as these are a commercial product I don't have access to. However, if you send untruncated logs to me I'll do my best.

        You can always rt this issue for DBD::ODBC if you like.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://892230]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (13)
As of 2014-12-19 10:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Is guessing a good strategy for surviving in the IT business?





    Results (77 votes), past polls