>
> > 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 $
Actually, that's not the version, in ODBC.pm, there's a VERSION=xxxx. No
big deal, though, since you are getting from ActiveState, it's 0.28. Can
you please try to use the latest from MY repository, listed in the FAQ (see
my signature at the end).
>
> > 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
This is newer than what I have.
>
> > 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.
It's *always* the 9th query, no matter what order these are in the loop? In
the example above, process(635, 'C', $i) fails the second time around, every
time?
>
> 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.
Ok -- then, let's keep it simple and send me the trace (level 8) for this
one.
>
> > 5) Can you try to re-prepare the query inside the loop to see if that
> > resolves it?
> I will try & post.
How did this go? Not what I want, but I'm just curious. If this works,
also post a level 8 trace (or e-mail it directly to me).
Thanks,
Jeff
=============================================
See the DBI FAQ at www.xmlproj.com/cgi/fom.cgi
