> One of the dsns must have a different default database. Did you try the
> other suggestion of putting the use in a different $dbh->do()?
>
i plan on giving that a shot today. i'll let you know the results.
-ap
__
Do you Yahoo!?
Yahoo! Tax Cen
>
> --- Jeff Urlwin <[EMAIL PROTECTED]> wrote:
> > Actually, it would also help if you sent me a trace file of what's
> > going on.
> >
>
> i've attached a zip containing four text files. note i get
> different errors when running the same script on win2k and
> win2k server. i'm not sure why.
On Tue, 2003-04-01 at 06:20, Adam Peterson wrote:
> here's a sample piece that works when i don't include "use eggsupp;"
> my $sql = "
> use eggsupp;
> select *
> from filesupp
> where owner like 'Adam%'
> ";
>
> $sth = $dbh->prepare($sql);
The "use " command ha
> my $sql = "
> use eggsupp;
> select *
> from filesupp
> where owner like 'Adam%'
> ";
>
Why don't you do:
$dbh->do('use eggsupp');
and then:
normally run your query, with that first 'use eggsupp' removed.
Waldemar
tead of your user)
> > > or
> > > b) the CGI script is pointing to a different perl than the one
> > > running from the command line.
> > >
> > > >
> > > > As far as a workaround, my answer would be go back a couple
> > > >
kage. It used to work. If you
> > > know where I can get older versions, please let me know.
> >
> > CPAN and building from the source can get you older versions.
> >
> > I put a lot of work in getting multiple statements to work and it
> > should work
C 2.x. Some things seem
> more
> "picky" with SQL Server's ODBC driver this way.
>
> Jeff
>
> >
> > Thanks
> >
> > E. Scott Stricker - NGIT @ Smartlink
> > - Original Message -
> > From: "Adam Peterson&quo
#x27;s ODBC driver this way.
Jeff
>
> Thanks
>
> E. Scott Stricker - NGIT @ Smartlink
> - Original Message -
> From: "Adam Peterson" <[EMAIL PROTECTED]>
> To: "E. Scott Stricker" <[EMAIL PROTECTED]>;
> <[EMAIL PROTECTED]>
&
ROTECTED]>; <[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!
>
>
>
cker - 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,
> >
> >
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 sc
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 be
12 matches
Mail list logo