Re: Mysterious query

From: Peter Michelson <pete77r_at_hotmail.com>
Date: Sat, 01 Mar 2003 04:33:14 GMT
Message-ID: <eKW7a.47926$ep5.27588@nwrddc02.gnilink.net>

"Ted McCabe" <theom_at_gte.net> wrote in message news:HFT7a.47257$ep5.9410_at_nwrddc02.gnilink.net...
> Peter:
> You might consider setting sqlnet trace on the client side to see if
it
> might be sending the query. Could be a rather large trace file.
> HTH
> ted

Ted:
Thanks for your suggestion. I wasn't the one who performed the trace (I stated thus for simplicity), but I believe it may have actually been done on the client side. I will look into this and try to get a trace at both ends to compare.
Thanks again,
-P

> "Peter Michelson" <pete77r_at_hotmail.com> wrote in message
> news:YlT7a.45160$_J5.34438_at_nwrddc01.gnilink.net...
> > Here's a poser: I have a Delphi 6 Enterprise app using the BDE to
connect
> to
> > Oracle 8.1.7.3. I've been getting sporadic "Ambiguous Column Name"
errors
> > from Oracle. When I ran SQL Trace it revealed an impossible query:
> > somehow, a query which contains all fields from all of my database
tables
> > was being processed. This query even contains fields from tables in the
> > database which aren't being used in the Delphi application. However, it
> > does not seem to contain any key fields.
> >
> > Does anyone have any idea what might cause this behavior? Could this
> result
> > from bad memory on the database server?
> >
> > Would appreciate any help,
> > -P
> >
> >

>
> Received on Fri Feb 28 2003 - 22:33:14 CST