I've just started to experiment with DBD-ADO 2.5. I'm trying to figure
out if it's a viable option to DBD-ODBC.
I've got this snippet of code that doesn't seem to work with DBD-ADO:
my $dbh = newDbh();
my $sth = $dbh->prepare("{call testPrc(?)}");
$sth->bind_param(1, 10, { TYPE => 4 });
$sth->execute();
print '$sth->{NUM_OF_FIELDS}: ', $sth->{NUM_OF_FIELDS}, "\n";
if($sth->{NUM_OF_FIELDS})
{ $sth->fetchrow_hashref('NAME');
}
I just get lots of errors like this (trace is attached):
OLE exception from "ADODB.Connection":
Object or provider is not capable of performing requested operation.
Win32::OLE(0.1502) error 0x800a0cb3
in METHOD/PROPERTYGET "OpenSchema" at E:/Perl/site/lib/DBD/ADO.pm
line 1402
OLE exception from "ADODB.Connection":
Object or provider is not capable of performing requested operation.
Win32::OLE(0.1502) error 0x800a0cb3
in METHOD/PROPERTYGET "OpenSchema" at E:/Perl/site/lib/DBD/ADO.pm
line 1402
OLE exception from "ADODB.Connection":
Object or provider is not capable of performing requested operation.
Win32::OLE(0.1502) error 0x800a0cb3
in METHOD/PROPERTYGET "OpenSchema" at E:/Perl/site/lib/DBD/ADO.pm
line 1402
OLE exception from "ADODB.Connection":
Object or provider is not capable of performing requested operation.
Win32::OLE(0.1502) error 0x800a0cb3
in METHOD/PROPERTYGET "OpenSchema" at E:/Perl/site/lib/DBD/ADO.pm
line 1402
OLE exception from "ADODB.Connection":
It just goes on like that.
Using SQL Profiler I can see that the code executes as it's supposed to
on the server.
Finally my questions:
1. Why do I get those errors?
2. Is DBD-ADO mature? Experiences?
3. Does DBD-ADO support input/output parameters for stored procedures?
Multiple result sets?
4. I've noticed that DBD-ADO call sp_sproc_columns for my sp's, can that
be avoided?
Thanks,
Roger P
DBI::st=HASH(0x29c16d0) trace level set to 4 in DBI 1.30-ithread
-> bind_param for DBD::ADO::st (DBI::st=HASH(0x29c31ec)~0x29c16d0 1 10
HASH(0x29be6e8)) thr#01B0F27C
1 <- FETCH= 1 ('NUM_OF_PARAMS' from cache) at ADO.pm line 1778 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 53
->(default) : 2 3
<- bind_param= 1 at DbiTest4ADO.pl line 53 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
-> execute for DBD::ADO::st (DBI::st=HASH(0x29c31ec)~0x29c16d0) thr#01B0F27C
1 <- FETCH= '{call testPrc(?)}' ('Statement' from cache) at ADO.pm line 1831 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
-> execute state handler
-> Not Supported flag: 0
-> Is the Parameter Object Supported? Yes
-> Parameter count: 1
-> Parameter 0: 10
-> Parameter 0: 10
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'ado_rowset'
Win32::OLE=HASH(0x29bcca8)) thr#01B0F27C
1 <- STORE= Win32::OLE=HASH(0x29bcca8) at ADO.pm line 2005 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'RowCacheSize')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c16d0) 'RowCacheSize' = undef
1 <- FETCH= undef at ADO.pm line 2008 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'NUM_OF_FIELDS')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c16d0) 'NUM_OF_FIELDS' = 0
1 <- FETCH= 0 at ADO.pm line 2020 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'Active' 1) thr#01B0F27C
STORE DBI::st=HASH(0x29c16d0) 'Active' => 1
1 <- STORE= 1 at ADO.pm line 2021 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'NUM_OF_FIELDS' 18)
thr#01B0F27C
STORE DBI::st=HASH(0x29c16d0) 'NUM_OF_FIELDS' => 18
1 <- STORE= 1 at ADO.pm line 2022 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'NAME' ARRAY(0x29b9644))
thr#01B0F27C
1 <- STORE= [ 'name' 'xtype' 'status' 'xusertype' 'length' 'xprec' 'xscale'
'tdefault' 'domain' 'uid' 'reserved' 'usertype' 'variable' 'allownulls' 'type'
'printfmt' 'prec' 'scale' ] at ADO.pm line 2024 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'TYPE' ARRAY(0x29a6e78))
thr#01B0F27C
1 <- STORE= [ -9 -9 undef 0 0 undef 0 0 undef 5 5 undef 5 5 undef 0 0 undef 0 0
undef 4 4 undef 4 4 undef 5 5 undef 5 5 undef 5 5 undef 16 16 undef 16 16 undef 0 0
undef 12 12 undef 5 5 undef 0 0 undef ] at ADO.pm line 2026 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'PRECISION'
ARRAY(0x29a8570)) thr#01B0F27C
1 <- STORE= [ 255 3 3 5 5 3 3 10 10 5 5 5 255 255 3 255 5 3 ] at ADO.pm line 2028
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'SCALE' ARRAY(0x29b7594))
thr#01B0F27C
1 <- STORE= [ 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255 255
255 ] at ADO.pm line 2030 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'NULLABLE'
ARRAY(0x29a7088)) thr#01B0F27C
1 <- STORE= [ 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 ] at ADO.pm line 2033 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'ado_type'
ARRAY(0x29a6f14)) thr#01B0F27C
1 <- STORE= [ 202 17 17 2 2 17 17 3 3 2 2 2 11 11 17 200 2 17 ] at ADO.pm line 2038
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'CursorName' undef)
thr#01B0F27C
1 <- STORE= undef at ADO.pm line 2049 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'Statement' '{call
testPrc(?)}') thr#01B0F27C
1 <- STORE= '{call testPrc(?)}' at ADO.pm line 2050 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'RowsInCache' 1)
thr#01B0F27C
1 <- STORE= 1 at ADO.pm line 2051 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'rows' -1) thr#01B0F27C
STORE DBI::st=HASH(0x29c16d0) 'rows' => -1
1 <- STORE= '' at ADO.pm line 2052 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 54
<- executed state handler
<- execute= -1 at DbiTest4ADO.pl line 54 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
<- FETCH= 18 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 56 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
<- FETCH= 18 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
-> fetchrow_hashref in DBD::_::st for DBD::ADO::st
(DBI::st=HASH(0x29c31ec)~0x29c16d0 'NAME') thr#01B0F27C
1 -> fetch for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER) thr#01B0F27C
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'Active') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c16d0) 'Active' = 1
2 <- FETCH= 1 at ADO.pm line 2068 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 57
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'ChopBlanks') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c16d0) 'ChopBlanks' = ''
2 <- FETCH= '' at ADO.pm line 2100 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 57
dbih_setup_fbav for 18 fields => 0x29a5b40
1 <- fetch= [ 'binary' 173 2 173 8000 0 0 0 0 1 0 3 0 1 45 undef 8000 undef ] row1
at DbiTest4ADO.pl line 57 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
1 <- FETCH= [ 'name' 'xtype' 'status' 'xusertype' 'length' 'xprec' 'xscale'
'tdefault' 'domain' 'uid' 'reserved' 'usertype' 'variable' 'allownulls' 'type'
'printfmt' 'prec' 'scale' ] ('NAME' from cache) at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
<- fetchrow_hashref= HASH(0x29a5ccc)18keys row1 at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 68
-> DESTROY for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER) thr#01B0F27C
<- destroy statement handler
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'ado_rowset' undef)
thr#01B0F27C
<- STORE= undef at ADO.pm line 2196 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 74
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c16d0)~INNER 'Active' 0) thr#01B0F27C
STORE DBI::st=HASH(0x29c16d0) 'Active' => 0
<- STORE= 1 at ADO.pm line 2197 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 74
-> destroy statement handler
<- DESTROY= undef at DbiTest4ADO.pl line 74
DBI::st=HASH(0x29c1cc8) trace level set to 4 in DBI 1.30-ithread
-> execute for DBD::ADO::st (DBI::st=HASH(0x29c3668)~0x29c1cc8) thr#01B0F27C
1 <- FETCH= 'select * from sysobjects' ('Statement' from cache) at ADO.pm line 1831
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
-> execute state handler
-> Not Supported flag: 0
-> Is the Parameter Object Supported? Yes
-> Parameter count: 0
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_rowset'
Win32::OLE=HASH(0x29bcfa0)) thr#01B0F27C
1 <- STORE= Win32::OLE=HASH(0x29bcfa0) at ADO.pm line 2005 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'RowCacheSize')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'RowCacheSize' = undef
1 <- FETCH= undef at ADO.pm line 2008 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NUM_OF_FIELDS')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'NUM_OF_FIELDS' = 0
1 <- FETCH= 0 at ADO.pm line 2020 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active' 1) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'Active' => 1
1 <- STORE= 1 at ADO.pm line 2021 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NUM_OF_FIELDS' 25)
thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'NUM_OF_FIELDS' => 25
1 <- STORE= 1 at ADO.pm line 2022 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NAME' ARRAY(0x29b84ac))
thr#01B0F27C
1 <- STORE= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] at ADO.pm line 2024 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'TYPE' ARRAY(0x29a5ae0))
thr#01B0F27C
1 <- STORE= [ -9 -9 undef 4 4 undef 12 12 undef 5 5 undef 5 5 undef 4 4 undef 4 4
undef 4 4 undef 4 4 undef 93 9 3 5 5 undef 4 4 undef 4 4 undef 12 12 undef 5 5 undef 5
5 undef 5 5 undef 93 9 3 4 4 undef 4 4 undef 4 4 undef 4 4 undef 4 4 undef 4 4 undef 5
5 undef ] at ADO.pm line 2026 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl
line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'PRECISION'
ARRAY(0x29b8740)) thr#01B0F27C
1 <- STORE= [ 255 10 255 5 5 10 10 10 10 23 5 10 10 255 5 5 5 23 10 10 10 10 10 10 5
] at ADO.pm line 2028 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'SCALE' ARRAY(0x29b6388))
thr#01B0F27C
1 <- STORE= [ 255 255 255 255 255 255 255 255 255 3 255 255 255 255 255 255 255 3
255 255 255 255 255 255 255 ] at ADO.pm line 2030 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NULLABLE'
ARRAY(0x29a4560)) thr#01B0F27C
1 <- STORE= [ 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 ] at ADO.pm line
2033 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_type'
ARRAY(0x29a5c30)) thr#01B0F27C
1 <- STORE= [ 202 3 129 2 2 3 3 3 3 135 2 3 3 129 2 2 2 135 3 3 3 3 3 3 2 ] at
ADO.pm line 2038 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'CursorName' undef)
thr#01B0F27C
1 <- STORE= undef at ADO.pm line 2049 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Statement' 'select *
from sysobjects') thr#01B0F27C
1 <- STORE= 'select * from sysobjects' at ADO.pm line 2050 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'RowsInCache' 1)
thr#01B0F27C
1 <- STORE= 1 at ADO.pm line 2051 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'rows' -1) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'rows' => -1
1 <- STORE= '' at ADO.pm line 2052 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
<- executed state handler
<- execute= -1 at DbiTest4ADO.pl line 55 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- FETCH= 25 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- FETCH= 25 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> fetchrow_hashref in DBD::_::st for DBD::ADO::st
(DBI::st=HASH(0x29c3668)~0x29c1cc8 'NAME') thr#01B0F27C
1 -> fetch for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER) thr#01B0F27C
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'Active' = 1
2 <- FETCH= 1 at ADO.pm line 2068 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 58
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ChopBlanks') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'ChopBlanks' = ''
2 <- FETCH= '' at ADO.pm line 2100 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 58
dbih_setup_fbav for 25 fields => 0x29a4788
1 <- fetch= [ 'sysobjects' 1 'S ' 1 25 -2147483645 105 0 0 '1998-11-13 03:00:19' 0
96 9 'S ' 1 113 0 '1998-11-13 03:00:19' 0 0 0 0 0 2 0 ] row1 at DbiTest4ADO.pl line 58
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
1 <- FETCH= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] ('NAME' from cache) at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- fetchrow_hashref= HASH(0x29a3f90)25keys row1 at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> DESTROY for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER) thr#01B0F27C
<- destroy statement handler
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_rowset' undef)
thr#01B0F27C
<- STORE= undef at ADO.pm line 2196 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 75
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active' 0) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'Active' => 0
<- STORE= 1 at ADO.pm line 2197 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 75
-> destroy statement handler
<- DESTROY= undef at DbiTest4ADO.pl line 75
DBI::st=HASH(0x29c1cc8) trace level set to 4 in DBI 1.30-ithread
-> execute for DBD::ADO::st (DBI::st=HASH(0x29c3668)~0x29c1cc8) thr#01B0F27C
1 <- FETCH= 'select * from sysobjects' ('Statement' from cache) at ADO.pm line 1831
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
-> execute state handler
-> Not Supported flag: 0
-> Is the Parameter Object Supported? Yes
-> Parameter count: 0
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_rowset'
Win32::OLE=HASH(0x29bcfa0)) thr#01B0F27C
1 <- STORE= Win32::OLE=HASH(0x29bcfa0) at ADO.pm line 2005 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'RowCacheSize')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'RowCacheSize' = undef
1 <- FETCH= undef at ADO.pm line 2008 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NUM_OF_FIELDS')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'NUM_OF_FIELDS' = 0
1 <- FETCH= 0 at ADO.pm line 2020 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active' 1) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'Active' => 1
1 <- STORE= 1 at ADO.pm line 2021 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NUM_OF_FIELDS' 25)
thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'NUM_OF_FIELDS' => 25
1 <- STORE= 1 at ADO.pm line 2022 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NAME' ARRAY(0x29b84ac))
thr#01B0F27C
1 <- STORE= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] at ADO.pm line 2024 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'TYPE' ARRAY(0x29a5ae0))
thr#01B0F27C
1 <- STORE= [ -9 -9 undef 4 4 undef 12 12 undef 5 5 undef 5 5 undef 4 4 undef 4 4
undef 4 4 undef 4 4 undef 93 9 3 5 5 undef 4 4 undef 4 4 undef 12 12 undef 5 5 undef 5
5 undef 5 5 undef 93 9 3 4 4 undef 4 4 undef 4 4 undef 4 4 undef 4 4 undef 4 4 undef 5
5 undef ] at ADO.pm line 2026 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl
line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'PRECISION'
ARRAY(0x29b8740)) thr#01B0F27C
1 <- STORE= [ 255 10 255 5 5 10 10 10 10 23 5 10 10 255 5 5 5 23 10 10 10 10 10 10 5
] at ADO.pm line 2028 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'SCALE' ARRAY(0x29b6388))
thr#01B0F27C
1 <- STORE= [ 255 255 255 255 255 255 255 255 255 3 255 255 255 255 255 255 255 3
255 255 255 255 255 255 255 ] at ADO.pm line 2030 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NULLABLE'
ARRAY(0x29a4560)) thr#01B0F27C
1 <- STORE= [ 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 ] at ADO.pm line
2033 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_type'
ARRAY(0x29a5c30)) thr#01B0F27C
1 <- STORE= [ 202 3 129 2 2 3 3 3 3 135 2 3 3 129 2 2 2 135 3 3 3 3 3 3 2 ] at
ADO.pm line 2038 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'CursorName' undef)
thr#01B0F27C
1 <- STORE= undef at ADO.pm line 2049 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Statement' 'select *
from sysobjects') thr#01B0F27C
1 <- STORE= 'select * from sysobjects' at ADO.pm line 2050 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'RowsInCache' 1)
thr#01B0F27C
1 <- STORE= 1 at ADO.pm line 2051 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'rows' -1) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'rows' => -1
1 <- STORE= '' at ADO.pm line 2052 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
<- executed state handler
<- execute= -1 at DbiTest4ADO.pl line 55 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- FETCH= 25 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- FETCH= 25 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> fetchrow_hashref in DBD::_::st for DBD::ADO::st
(DBI::st=HASH(0x29c3668)~0x29c1cc8 'NAME') thr#01B0F27C
1 -> fetch for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER) thr#01B0F27C
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'Active' = 1
2 <- FETCH= 1 at ADO.pm line 2068 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 58
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ChopBlanks') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'ChopBlanks' = ''
2 <- FETCH= '' at ADO.pm line 2100 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 58
dbih_setup_fbav for 25 fields => 0x29a4788
1 <- fetch= [ 'sysobjects' 1 'S ' 1 25 -2147483645 105 0 0 '1998-11-13 03:00:19' 0
96 9 'S ' 1 113 0 '1998-11-13 03:00:19' 0 0 0 0 0 2 0 ] row1 at DbiTest4ADO.pl line 58
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
1 <- FETCH= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] ('NAME' from cache) at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- fetchrow_hashref= HASH(0x29a3f90)25keys row1 at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> DESTROY for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER) thr#01B0F27C
<- destroy statement handler
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_rowset' undef)
thr#01B0F27C
<- STORE= undef at ADO.pm line 2196 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 75
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active' 0) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'Active' => 0
<- STORE= 1 at ADO.pm line 2197 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 75
-> destroy statement handler
<- DESTROY= undef at DbiTest4ADO.pl line 75
DBI::st=HASH(0x29c1cc8) trace level set to 4 in DBI 1.30-ithread
-> execute for DBD::ADO::st (DBI::st=HASH(0x29c3668)~0x29c1cc8) thr#01B0F27C
1 <- FETCH= 'select * from sysobjects' ('Statement' from cache) at ADO.pm line 1831
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
-> execute state handler
-> Not Supported flag: 0
-> Is the Parameter Object Supported? Yes
-> Parameter count: 0
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_rowset'
Win32::OLE=HASH(0x29bcfa0)) thr#01B0F27C
1 <- STORE= Win32::OLE=HASH(0x29bcfa0) at ADO.pm line 2005 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'RowCacheSize')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'RowCacheSize' = undef
1 <- FETCH= undef at ADO.pm line 2008 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NUM_OF_FIELDS')
thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'NUM_OF_FIELDS' = 0
1 <- FETCH= 0 at ADO.pm line 2020 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active' 1) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'Active' => 1
1 <- STORE= 1 at ADO.pm line 2021 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NUM_OF_FIELDS' 25)
thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'NUM_OF_FIELDS' => 25
1 <- STORE= 1 at ADO.pm line 2022 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NAME' ARRAY(0x29b84ac))
thr#01B0F27C
1 <- STORE= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] at ADO.pm line 2024 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
-> _determine_type_support
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'TYPE' ARRAY(0x29a5ae0))
thr#01B0F27C
1 <- STORE= [ -9 -9 undef 4 4 undef 12 12 undef 5 5 undef 5 5 undef 4 4 undef 4 4
undef 4 4 undef 4 4 undef 93 9 3 5 5 undef 4 4 undef 4 4 undef 12 12 undef 5 5 undef 5
5 undef 5 5 undef 93 9 3 4 4 undef 4 4 undef 4 4 undef 4 4 undef 4 4 undef 4 4 undef 5
5 undef ] at ADO.pm line 2026 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl
line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'PRECISION'
ARRAY(0x29b8740)) thr#01B0F27C
1 <- STORE= [ 255 10 255 5 5 10 10 10 10 23 5 10 10 255 5 5 5 23 10 10 10 10 10 10 5
] at ADO.pm line 2028 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'SCALE' ARRAY(0x29b6388))
thr#01B0F27C
1 <- STORE= [ 255 255 255 255 255 255 255 255 255 3 255 255 255 255 255 255 255 3
255 255 255 255 255 255 255 ] at ADO.pm line 2030 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'NULLABLE'
ARRAY(0x29a4560)) thr#01B0F27C
1 <- STORE= [ 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 1 1 1 1 1 1 1 ] at ADO.pm line
2033 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_type'
ARRAY(0x29a5c30)) thr#01B0F27C
1 <- STORE= [ 202 3 129 2 2 3 3 3 3 135 2 3 3 129 2 2 2 135 3 3 3 3 3 3 2 ] at
ADO.pm line 2038 via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'CursorName' undef)
thr#01B0F27C
1 <- STORE= undef at ADO.pm line 2049 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Statement' 'select *
from sysobjects') thr#01B0F27C
1 <- STORE= 'select * from sysobjects' at ADO.pm line 2050 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'RowsInCache' 1)
thr#01B0F27C
1 <- STORE= 1 at ADO.pm line 2051 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
1 -> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'rows' -1) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'rows' => -1
1 <- STORE= '' at ADO.pm line 2052 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 55
<- executed state handler
<- execute= -1 at DbiTest4ADO.pl line 55 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- FETCH= 25 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- FETCH= 25 ('NUM_OF_FIELDS' from cache) at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> fetchrow_hashref in DBD::_::st for DBD::ADO::st
(DBI::st=HASH(0x29c3668)~0x29c1cc8 'NAME') thr#01B0F27C
1 -> fetch for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER) thr#01B0F27C
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'Active' = 1
2 <- FETCH= 1 at ADO.pm line 2068 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 58
2 -> FETCH for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ChopBlanks') thr#01B0F27C
.. FETCH DBI::st=HASH(0x29c1cc8) 'ChopBlanks' = ''
2 <- FETCH= '' at ADO.pm line 2100 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 58
dbih_setup_fbav for 25 fields => 0x29a4788
1 <- fetch= [ 'sysobjects' 1 'S ' 1 25 -2147483645 105 0 0 '1998-11-13 03:00:19' 0
96 9 'S ' 1 113 0 '1998-11-13 03:00:19' 0 0 0 0 0 2 0 ] row1 at DbiTest4ADO.pl line 58
via E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
1 <- FETCH= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] ('NAME' from cache) at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- fetchrow_hashref= HASH(0x29a3f90)25keys row1 at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> DESTROY for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER) thr#01B0F27C
<- destroy statement handler
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'ado_rowset' undef)
thr#01B0F27C
<- STORE= undef at ADO.pm line 2196 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 75
-> STORE for DBD::ADO::st (DBI::st=HASH(0x29c1cc8)~INNER 'Active' 0) thr#01B0F27C
STORE DBI::st=HASH(0x29c1cc8) 'Active' => 0
<- STORE= 1 at ADO.pm line 2197 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 75
-> destroy statement handler
<- DESTROY= undef at DbiTest4ADO.pl line 75
DBI::st=HASH(0x1e69364) trace level set to 4 in DBI 1.30-ithread
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1dd4350)~0x1e69364) thr#01B0F27C
dbd_st_execute (outparams = 0)...
dbd_st_execute (for hstmt 32057520 before)...
dbd_describe sql 32057520: num_fields=25
col 1: UNICODE VARCHAR len=256 disp=129, prec=128 scale=0
col 2: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 3: CHAR len= 2 disp= 3, prec= 2 scale=0
col 4: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 5: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 6: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 7: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 8: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 9: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 10: TIMESTAMP len= 16 disp= 24, prec= 23 scale=3
col 11: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 12: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 13: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 14: CHAR len= 2 disp= 3, prec= 2 scale=0
col 15: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 16: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 17: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 18: TIMESTAMP len= 16 disp= 24, prec= 23 scale=3
col 19: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 20: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 21: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 22: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 23: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 24: INTEGER len= 4 disp= 12, prec= 10 scale=0
col 25: SMALLINT len= 2 disp= 7, prec= 5 scale=0
col 1: 'name' sqltype=UNICODE VARCHAR, ctype=SQL_C_CHAR, maxlen=129, (dp = 0,
cp = 0)
col 2: 'id' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 132, cp = 5)
col 3: 'xtype' sqltype=CHAR, ctype=SQL_C_CHAR, maxlen=3, (dp = 144, cp = 8)
col 4: 'uid' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 148, cp = 14)
col 5: 'info' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 156, cp = 18)
col 6: 'status' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 164, cp =
23)
col 7: 'base_schema_ver' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp =
176, cp = 30)
col 8: 'replinfo' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 188, cp =
46)
col 9: 'parent_obj' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 200, cp
= 55)
col 10: 'crdate' sqltype=TIMESTAMP, ctype=SQL_C_CHAR, maxlen=24, (dp = 212, cp =
66)
col 11: 'ftcatid' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 236, cp =
73)
col 12: 'schema_ver' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 244, cp
= 81)
col 13: 'stats_schema_ver' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp =
256, cp = 92)
col 14: 'type' sqltype=CHAR, ctype=SQL_C_CHAR, maxlen=3, (dp = 268, cp = 109)
col 15: 'userstat' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 272, cp =
114)
col 16: 'sysstat' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 280, cp =
123)
col 17: 'indexdel' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 288, cp =
131)
col 18: 'refdate' sqltype=TIMESTAMP, ctype=SQL_C_CHAR, maxlen=24, (dp = 296, cp
= 140)
col 19: 'version' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 320, cp =
148)
col 20: 'deltrig' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 332, cp =
156)
col 21: 'instrig' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 344, cp =
164)
col 22: 'updtrig' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 356, cp =
172)
col 23: 'seltrig' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 368, cp =
180)
col 24: 'category' sqltype=INTEGER, ctype=SQL_C_CHAR, maxlen=12, (dp = 380, cp =
188)
col 25: 'cache' sqltype=SMALLINT, ctype=SQL_C_CHAR, maxlen=7, (dp = 392, cp =
197)
<- execute= -1 at DbiTest4ADO.pl line 55 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> FETCH for DBD::ODBC::st (DBI::st=HASH(0x1e69364)~INNER 'NUM_OF_FIELDS')
thr#01B0F27C
<- FETCH= 25 at DbiTest4ADO.pl line 57 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> FETCH for DBD::ODBC::st (DBI::st=HASH(0x1e69364)~INNER 'NUM_OF_FIELDS')
thr#01B0F27C
<- FETCH= 25 at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> fetchrow_hashref in DBD::_::st for DBD::ODBC::st
(DBI::st=HASH(0x1dd4350)~0x1e69364 'NAME') thr#01B0F27C
1 -> fetch for DBD::ODBC::st (DBI::st=HASH(0x1e69364)~INNER) thr#01B0F27C
SQLFetch rc 0
dbih_setup_fbav for 25 fields => 0x1dd453c
fetch num_fields=25
fetch col#0 name datalen=10 displ=129
fetch col#1 id datalen=1 displ=12
fetch col#2 xtype datalen=2 displ=3
fetch col#3 uid datalen=1 displ=7
fetch col#4 info datalen=2 displ=7
fetch col#5 status datalen=11 displ=12
fetch col#6 base_schema_ver datalen=3 displ=12
fetch col#7 replinfo datalen=1 displ=12
fetch col#8 parent_obj datalen=1 displ=12
fetch col#9 crdate datalen=23 displ=24
fetch col#10 ftcatid datalen=1 displ=7
fetch col#11 schema_ver datalen=2 displ=12
fetch col#12 stats_schema_ver datalen=1 displ=12
fetch col#13 type datalen=2 displ=3
fetch col#14 userstat datalen=1 displ=7
fetch col#15 sysstat datalen=3 displ=7
fetch col#16 indexdel datalen=1 displ=7
fetch col#17 refdate datalen=23 displ=24
fetch col#18 version datalen=1 displ=12
fetch col#19 deltrig datalen=1 displ=12
fetch col#20 instrig datalen=1 displ=12
fetch col#21 updtrig datalen=1 displ=12
fetch col#22 seltrig datalen=1 displ=12
fetch col#23 category datalen=1 displ=12
fetch col#24 cache datalen=1 displ=7
1 <- fetch= [ 'sysobjects' '1' 'S ' '1' '25' '-2147483645' '105' '0' '0' '1998-11-13
03:00:19.187' '0' '96' '9' 'S ' '1' '113' '0' '1998-11-13 03:00:19.187' '0' '0' '0'
'0' '0' '2' '0' ] row1 at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
1 -> FETCH for DBD::ODBC::st (DBI::st=HASH(0x1e69364)~INNER 'NAME') thr#01B0F27C
1 <- FETCH= [ 'name' 'id' 'xtype' 'uid' 'info' 'status' 'base_schema_ver' 'replinfo'
'parent_obj' 'crdate' 'ftcatid' 'schema_ver' 'stats_schema_ver' 'type' 'userstat'
'sysstat' 'indexdel' 'refdate' 'version' 'deltrig' 'instrig' 'updtrig' 'seltrig'
'category' 'cache' ] at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
<- fetchrow_hashref= HASH(0x1dcc740)25keys row1 at DbiTest4ADO.pl line 58 via
E:\Projekt\Helpdesk\Perl\UpgradeDB\DbiTest4ADO.pl line 69
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1e69364)~INNER) thr#01B0F27C
<- DESTROY= undef at DbiTest4ADO.pl line 75
