Strangely enough, splitting the request into 2, first is Use db and second
is whatever else still seems to work. Not sure why. Also, problem seems to
be confined to scripts run for the DOS prompt. CGI scripts we have still
work fine.
As far as a workaround, my answer would be go back a couple of versions of
the ODBC package. It used to work. If you know where I can get older
versions, please let me know.
Thanks
E. Scott Stricker - NGIT @ Smartlink
----- Original Message -----
From: "Adam Peterson" <[EMAIL PROTECTED]>
To: "E. Scott Stricker" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, March 27, 2003 8:55 AM
Subject: Re: DBD-ODBC Strange Behavior?
> is there anyway to get around this? this could case a lot of problems if
> someone by mistake switched the default database on the system dsn name!
>
>
>
>
> --- "E. Scott Stricker" <[EMAIL PROTECTED]> wrote:
> > Getting the same thing with the newer versions of DBD-ODBC. The generic
> > behavior is that the software no longer seems to support batches. We've
> > had
> > the same problem with any sql statement containing multiple sql commands
> > (in
> > this case USE is the first and SELECT is the second). Used to work with
> > older software.
> >
> > E. Scott Stricker - NGIT @ Smartlink
> > ----- Original Message -----
> > From: "Adam Peterson" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, March 26, 2003 4:59 PM
> > Subject: DBD-ODBC Strange Behavior?
> >
> >
> > > hello,
> > >
> > > i'm running my script on a win2000 box called eggpayorteam. i have
> > > established a ODBC system DSN name of "eggpayorteam" and have set the
> > > default database to "eggsupp". when i run my queries below i get
> > errors,
> > > noted further below. when i remove "use eggsupp" it runs fine. is this
> > > strange behavior? and why is this happening?
> > >
> > > sth = $dbh->prepare("
> > > use eggsupp
> > > select count(fileid) as number from filesupp fs
> > > where datecreated >= '$past' and datecreated <= '$today'
> > > ");
> > >
> > > $sth->execute;
> > >
> > > while( my @data = $sth->fetchrow_array)
> > > {
> > > $total_num = $data[0];
> > > print "$total_num\n\n\n";
> > > }
> > >
> > > ###### query 2#
> > >
> > > $sth = $dbh->prepare("
> > > use eggsupp
> > > select count(fileid), crashtypedescr
> > > from filesupp fs join crashtype ct on fs.crashtype = ct.crashtypeid
> > > where crashtype <> ''
> > > and datecreated >= '$past' and datecreated <= '$today'
> > > group by crashtype,crashtypedescr
> > > ");
> > >
> > > $sth->execute;
> > >
> > > ---------------------
> > >
> > >
> > > DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> > Driver]Invalid
> > > cursor
> > > state (SQL-24000)(DBD: dbd_describe/SQLNumResultCols err=-1) at
> > > C:\perl\scripts\
> > > crash_pie.pl line 59.
> > > DBD::ODBC::st fetchrow_array failed: (DBD: no select statement
> > currently
> > > executi
> > > ng err=-1) at C:\perl\scripts\crash_pie.pl line 61.
> > > DBD::ODBC::st execute failed: [Microsoft][ODBC SQL Server
> > Driver]Invalid
> > > cursor
> > > state (SQL-24000)(DBD: dbd_describe/SQLNumResultCols err=-1) at
> > > C:\perl\scripts\
> > > crash_pie.pl line 77.
> > > DBD::ODBC::st fetchrow_array failed: (DBD: no select statement
> > currently
> > > executi
> > > ng err=-1) at C:\perl\scripts\crash_pie.pl line 79.
> > >
> > > __________________________________________________
> > > Do you Yahoo!?
> > > Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> > > http://platinum.yahoo.com
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
> http://platinum.yahoo.com
