Hi Jeff,
Sorry for the slow replies, and thanks for your help here.
> 1) What version of DBD::ODBC are you using?
I picked up off ActiveState -- the $id line is:
# $Id: ODBC.pm,v 1.12 1998/08/14 19:29:50 timbo Exp $
> 2) What version of Access are you using? What version of the ODBC driver
> for Access are you using? (see the ODBC control panel applet for this)
This is Access XP:
Microsoft Access 2002 (10.3409.3501) SP-1
Due to other software conflicts I cannot upgrade to SP-2, but I also
found this error on core Access 2002, without any Service Packs
ODBC Driver Version: 4.00.6019.00
The ODBC Core DLLs are all version: 3.520.9030.0
Except for:
Control Panel Device (odbccp32.cpl) 3.520.7713.0
Localized Resource DLL (odbcint.dll) 3.520.7713.0
> 3) Does it always stop at the same point?
Not quite. The core for-loop is:
for (my $i = 0; $i < 7; $i++) {
process(635, 'T', $i);
process(532, 'T', $i);
process(635, 'C', $i);
process(532, 'C', $i);
process(635, 'A', $i);
process(532, 'A', $i);
}
If I run it like that, it *always* stops after 8 queries are processed
(i.e. one iteration of i and 2/6 queries on the second iteration of $i).
It doesn't matter if I start at $i = 0 or $i=5. It also doesn't matter
which order I place these queries in.
HOWEVER, if I restrict the loop to just two queries:
for (my $i = 0; $i < 7; $i++) {
process(635, 'A', $i);
process(532, 'A', $i);
}
Then it will crash immediately following one loop iteration. So, in this
case it only runs *two* queries, not eight, before crashing.
> 4) Do you see if memory consumption is going up through the loop?
As best as I can tell, no. These are fairly lengthy queries so I'm not
100% sure. There is some memory change just because of the query itself,
but that seems to be pretty constant throughout the loop.
> 5) Can you try to re-prepare the query inside the loop to see if that
> resolves it?
I will try & post.
> Please post (at least to me) a *complete* trace (including the statement
> prepare calls). I know it may be big but, it's worth it. Let's start at
> level two, to get a feel for what's going on.
I'm attaching traces for both single-dbh and multiple-dbh runs. I have
removed the code that would actually retrieve rows to minimize the
trace-size. The crash occurs whether or not they are present, but if they
would help just let me know. Trace is at level 2.
<snip previous messages>
DBI 1.28-nothread dispatch trace level set to 2
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1afca68)~0x1afc990 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 2 distinct placeholders
dbd_st_prepare'd sql f28973256
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?
AND OCI_ARRAYS.IS_CONTROL = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afca80) at errortest.pl line 78
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1afca68)~0x1afc990 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 2 distinct placeholders
dbd_st_prepare'd sql f28974288
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?
AND OCI_ARRAYS.IS_CONTROL = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afcb64) at errortest.pl line 79
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1afca68)~0x1afc990 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 1 distinct placeholders
dbd_st_prepare'd sql f28975368
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afcc3c) at errortest.pl line 80
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1afca68)~0x1afc990 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 1 distinct placeholders
dbd_st_prepare'd sql f28977136
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afccfc) at errortest.pl line 81
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1afcc3c)~0x1afcc78 1)
bind 1 <== '1' (attribs: )
bind 1 <== 1 (size 1/2/0, ptype 6, otype 1)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=1.
dbd_st_execute (for sql f28975368 after)...
dbd_describe sql 28975368: num_fields=7
col 1: VARCHAR len= 15 disp= 16, prec= 15 scale=0
col 2: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 3: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 4: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 5: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 6: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 7: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 1: 'DAUGHTER' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=16
col 2: '12243856' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 3: '12243857' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 4: '12243858' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 5: '12243904' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 6: '12243905' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 7: '12244199' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
<- execute= -1 at errortest.pl line 156
-> finish for DBD::ODBC::st (DBI::st=HASH(0x1afcc3c)~0x1afcc78)
<- finish= 1 at errortest.pl line 168
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1afccfc)~0x1afa40c 1)
bind 1 <== '1' (attribs: )
bind 1 <== 1 (size 1/2/0, ptype 6, otype 1)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=1.
dbd_st_execute (for sql f28977136 after)...
dbd_describe sql 28977136: num_fields=7
col 1: VARCHAR len= 15 disp= 16, prec= 15 scale=0
col 2: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 3: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 4: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 5: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 6: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 7: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 1: 'DAUGHTER' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=16
col 2: '12243856' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 3: '12243857' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 4: '12243858' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 5: '12243904' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 6: '12243905' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 7: '12244199' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
<- execute= -1 at errortest.pl line 156
-> finish for DBD::ODBC::st (DBI::st=HASH(0x1afccfc)~0x1afa40c)
<- finish= 1 at errortest.pl line 168
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1afcc3c)~0x1afcc78 2)
bind 1 <== '2' (attribs: )
bind 1 <== 2 (size 1/2/1, ptype 6, otype 1)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=1.
dbd_st_execute (for sql f28975368 after)...
st_execute/SQLExecute error -1 recorded: [Microsoft][ODBC Microsoft Access Driver]
Operation is not supported for this type of object. (SQL-S1000)(DBD:
st_execute/SQLExecute err=-1)
!! ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Operation is not supported
for this type of object. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)'
<- execute= undef at errortest.pl line 156
-- DBI::END
-> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x1b70874)~0x1afcaa4)
<- disconnect_all= '' at DBI.pm line 552
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1afcc78)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1afc990)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY in DBD::_::common for DBD::ODBC::dr (DBI::dr=HASH(0x1afcaa4)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1afa40c)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x183f214)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1afcba0)~INNER)
<- DESTROY= undef during global destruction
DBI 1.28-nothread dispatch trace level set to 2
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1b00020)~0x1afff48 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 2 distinct placeholders
dbd_st_prepare'd sql f28973472
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?
AND OCI_ARRAYS.IS_CONTROL = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afe9b0) at errortest.pl line 81
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1b00038)~0x1835348 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 2 distinct placeholders
dbd_st_prepare'd sql f28974264
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?
AND OCI_ARRAYS.IS_CONTROL = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afea1c) at errortest.pl line 82
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1afe848)~0x1afe824 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 1 distinct placeholders
dbd_st_prepare'd sql f28975056
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S532_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afeaf4) at errortest.pl line 83
-> prepare for DBD::ODBC::db (DBI::db=HASH(0x1afe8fc)~0x1afe8d8 '
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND ...')
dbd_preparse scanned 1 distinct placeholders
dbd_st_prepare'd sql f28976944
TRANSFORM IIf( Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN) > 0,
Avg(VIEW_GPR_DATA_MM_FILTERED.S635_MEDIAN),
NULL) AS AvgOfMedian
SELECT VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
FROM VIEW_GPR_DATA_MM_FILTERED
WHERE VIEW_GPR_DATA_MM_FILTERED.BARCODE IN (
SELECT OCI_ARRAYS.BARCODE
FROM OCI_ARRAYS,
QRY_ARRAYS_TO_ANALYZE
WHERE OCI_ARRAYS.BARCODE = QRY_ARRAYS_TO_ANALYZE.BARCODE
AND OCI_ARRAYS.STRAIN_ID = ?)
GROUP BY VIEW_GPR_DATA_MM_FILTERED.DAUGHTER
PIVOT VIEW_GPR_DATA_MM_FILTERED.BARCODE
<- prepare= DBI::st=HASH(0x1afc604) at errortest.pl line 84
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1afeaf4)~0x1afeb30 1)
bind 1 <== '1' (attribs: )
bind 1 <== 1 (size 1/2/0, ptype 6, otype 1)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=1.
dbd_st_execute (for sql f28975056 after)...
dbd_describe sql 28975056: num_fields=7
col 1: VARCHAR len= 15 disp= 16, prec= 15 scale=0
col 2: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 3: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 4: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 5: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 6: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 7: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 1: 'DAUGHTER' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=16
col 2: '12243856' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 3: '12243857' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 4: '12243858' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 5: '12243904' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 6: '12243905' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 7: '12244199' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
<- execute= -1 at errortest.pl line 133
-> finish for DBD::ODBC::st (DBI::st=HASH(0x1afeaf4)~0x1afeb30)
<- finish= 1 at errortest.pl line 144
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1afc604)~0x1afc634 1)
bind 1 <== '1' (attribs: )
bind 1 <== 1 (size 1/2/0, ptype 6, otype 1)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=1.
dbd_st_execute (for sql f28976944 after)...
dbd_describe sql 28976944: num_fields=7
col 1: VARCHAR len= 15 disp= 16, prec= 15 scale=0
col 2: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 3: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 4: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 5: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 6: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 7: DOUBLE len= 8 disp= 23, prec= 15 scale=0
col 1: 'DAUGHTER' sqltype=VARCHAR, ctype=SQL_C_CHAR, maxlen=16
col 2: '12243856' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 3: '12243857' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 4: '12243858' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 5: '12243904' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 6: '12243905' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
col 7: '12244199' sqltype=DOUBLE, ctype=SQL_C_CHAR, maxlen=23
<- execute= -1 at errortest.pl line 133
-> finish for DBD::ODBC::st (DBI::st=HASH(0x1afc604)~0x1afc634)
<- finish= 1 at errortest.pl line 144
-> execute for DBD::ODBC::st (DBI::st=HASH(0x1afeaf4)~0x1afeb30 2)
bind 1 <== '2' (attribs: )
bind 1 <== 2 (size 1/2/1, ptype 6, otype 1)
bind 1: CTy=1, STy=VARCHAR, CD=80, Sc=0, VM=1.
dbd_st_execute (for sql f28975056 after)...
st_execute/SQLExecute error -1 recorded: [Microsoft][ODBC Microsoft Access Driver]
Operation is not supported for this type of object. (SQL-S1000)(DBD:
st_execute/SQLExecute err=-1)
!! ERROR: -1 '[Microsoft][ODBC Microsoft Access Driver] Operation is not supported
for this type of object. (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)'
<- execute= undef at errortest.pl line 133
-- DBI::END
-> disconnect_all for DBD::ODBC::dr (DBI::dr=HASH(0x1b70874)~0x1b0005c)
<- disconnect_all= '' at DBI.pm line 552
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1afe8d8)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x183f1fc)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1afff48)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1afeb30)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1afe824)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::db (DBI::db=HASH(0x1835348)~INNER)
<- DESTROY= undef during global destruction
-> DESTROY for DBD::ODBC::st (DBI::st=HASH(0x1afc634)~INNER)
