I made the changes you suggested and got a little more output, but I'm not sure what this telling me... except is this showing a failure before trying to set autocommit, possibly on a dead connection?
delli28@apsa9012:/u/delli28> test.pl
DBI 1.615-ithread default trace level set to 0x6000000/15 (pid 888
+884 pi 20009e68) at test.pl line 8
-> DBI->connect(dbi:ODBC:nhitest, delli28, ****, HASH(0x2000ab38))
-> DBI->install_driver(ODBC) for aix perl=5.008008 pid=888884 ruid
+=43679 euid=43679
install_driver: DBD::ODBC version 1.25 loaded from /u/delli28/l
+ib/site_perl/5.8.8/aix-thread-multi/DBD/ODBC.pm
New 'DBI::dr' (for DBD::ODBC::dr, parent='', id=undef)
dbih_setup_handle(DBI::dr=HASH(0x2052e7d4)=>DBI::dr=HASH(0x2052d27
+c), DBD::ODBC::dr, 0, Null!)
dbih_make_com(Null!, 0, DBD::ODBC::dr, 92, 0) thr#20009e68
dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), Err, Null!) SCALAR(0x2
+0411574) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), State, Null!) SCALAR(0
+x204115bc) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), Errstr, Null!) SCALAR(
+0x20411598) (already defined)
dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), TraceLevel, Null!) 0 (
+already defined)
dbih_setup_attrib(DBI::dr=HASH(0x2052d27c), FetchHashKeyName, Null
+!) 'NAME' (already defined)
install_method DBI::st::odbc_lob_read
<- install_driver= DBI::dr=HASH(0x2052e7d4)
>> connect DISPATCH (DBI::dr=HASH(0x2052e7d4) rc2/3 @5 g0 ima8
+001 pid#888884) at /u/delli28/lib/site_perl/5.8.8/aix-thread-multi/DB
+I.pm line 665
!! warn: 0 CLEARED by call to connect method
-> connect for DBD::ODBC::dr (DBI::dr=HASH(0x2052e7d4)~0x2052d27c
+'nhitest' 'delli28' **** HASH(0x2025d028)) thr#20009e68
New 'DBI::db' (for DBD::ODBC::db, parent=DBI::dr=HASH(0x2052d27c),
+ id=undef)
dbih_setup_handle(DBI::db=HASH(0x2052ebdc)=>DBI::db=HASH(0x2052eb4
+0), DBD::ODBC::db, 204a3608, Null!)
dbih_make_com(DBI::dr=HASH(0x2052d27c), 205342f8, DBD::ODBC::db, 4
+48, 0) thr#20009e68
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Err, DBI::dr=HASH(0x20
+52d27c)) SCALAR(0x204a3794) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), State, DBI::dr=HASH(0x
+2052d27c)) SCALAR(0x204a37f4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Errstr, DBI::dr=HASH(0
+x2052d27c)) SCALAR(0x204a37c4) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), TraceLevel, DBI::dr=HA
+SH(0x2052d27c)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), FetchHashKeyName, DBI:
+:dr=HASH(0x2052d27c)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), HandleSetErr, DBI::dr=
+HASH(0x2052d27c)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), HandleError, DBI::dr=H
+ASH(0x2052d27c)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), ReadOnly, DBI::dr=HASH
+(0x2052d27c)) undef (not defined)
dbih_setup_attrib(DBI::db=HASH(0x2052eb40), Profile, DBI::dr=HASH(
+0x2052d27c)) undef (not defined)
non-Unicode login6
dbd_db_login6
!!dbd_error2(err_rc=0, what=db_login/SQLAllocHandle(env), handles=
+(0,0,0)
SQLDriverConnect 'nhitest', 'delli28', 'xxxx'
SQLDriverConnect failed:
SQLConnect 'nhitest', 'delli28'
Turning autocommit on
Illegal instruction
delli28@apsa9012:/u/delli28>
|