Folks,
Here is the DBI trace of trying to get data from an MS-SQL Database from
solaris8. Note that it gets the field names, but no data.
keith
DBI::db=HASH(0x109d64) trace level set to 9 in DBI 1.19-nothread
Note: perl is running without the recommended perl -w option
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x109e24)~0x109d64
'select * from table1')
dbih_setup_handle(DBI::st=HASH(0x109e60)=>DBI::st=HASH(0x190fa4),
DBD::ODBC::st, 109e9c, Null!)
dbih_make_com(DBI::db=HASH(0x109d64), DBD::ODBC::st, 164)
dbih_setup_attrib(DBI::st=HASH(0x190fa4), Err,
DBI::db=HASH(0x109d64)) SCALAR(0x10542c) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x190fa4), State,
DBI::db=HASH(0x109d64)) SCALAR(0x105474) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x190fa4), Errstr,
DBI::db=HASH(0x109d64)) SCALAR(0x105450) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x190fa4), Handlers,
DBI::db=HASH(0x109d64)) ARRAY(0x109de8) (already defined)
dbih_setup_attrib(DBI::st=HASH(0x190fa4), Debug,
DBI::db=HASH(0x109d64)) 9 (already defined)
dbih_setup_attrib(DBI::st=HASH(0x190fa4), FetchHashKeyName,
DBI::db=HASH(0x109d64)) 'NAME' (already defined)
dbd_st_prepare'd sql f2649272
select * from table1
<- prepare= DBI::st=HASH(0x109e60) at
/usr/local/lib/perl5/site_perl/5.6.1/Acu/EclassDb.pm line 85
-> execute for DBD::ODBC::st (DBI::st=HASH(0x109e60)~0x190fa4)
dbd_st_execute (for sql f2649272 after)...
dbd_describe sql 2649272: num_fields=4
col 1: VARBINARY len= 8 disp= 17, prec= 8 scale=0
col 2: VARCHAR len= 51 disp= 51, prec= 50 scale=0
col 3: VARCHAR len= 51 disp= 51, prec= 50 scale=0
col 4: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 1: 'id' sqltype=VARBINARY, ctype=SQL_C_BINARY, maxlen=17
col 2: 'lname' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=51
col 3: 'fname' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=51
col 4: 'age' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12
<- execute= -1 at
/usr/local/lib/perl5/site_perl/5.6.1/Acu/EclassDb.pm line 92
-> rows for DBD::ODBC::st (DBI::st=HASH(0x109e60)~0x190fa4)
<- rows= -1 at /usr/local/lib/perl5/site_perl/5.6.1/Acu/EclassDb.pm
line 98
-> FETCH for DBD::ODBC::st (DBI::st=HASH(0x190fa4)~INNER 'NAME')
<- FETCH= [ 'id' 'lname' 'fname' 'age' ] at
/usr/local/lib/perl5/site_perl/5.6.1/Acu/EclassDb.pm line 99
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x190fa4)~INNER)
<- DESTROY= undef at
/usr/local/lib/perl5/site_perl/5.6.1/Acu/Eclass.pm line 434
-> $DBI::err (*) FETCH from lasth=DBI::db=HASH(0x109d64)
<- err= undef
-> $DBI::err (*) FETCH from lasth=DBI::db=HASH(0x109d64)
<- err= undef
-> disconnect for DBD::ODBC::db (DBI::db=HASH(0x109e24)~0x109d64)
<- disconnect= 1 at
/usr/local/lib/perl5/site_perl/5.6.1/Acu/EclassDb.pm line 125
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x109d64)~INNER)
<- DESTROY= undef during global destruction
0:No records found:
ROWS:
--
-------------------------------------------------
Keith Clay, [EMAIL PROTECTED]
Lead Programmer, Web Integration and Programming
286 Adams Center for Teaching Excellence
Abilene Christian University
Abilene, TX 79699
(915) 674-2187
(915) 674-2834
-------------------------------------------------
