Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Mysterious query
Morning Peter,
my Delphi is a bit rusty, but whenever I used to use the DBE to connect to Oracle, I never had to go via ODBC. I'm surprised that your app seems to be doing so. I never had an Enterprise Edition of Delphi, so I don't know off hand what connectivity you get with it, but checking on the Delphi pages at Borland, I see that Oracle direct connection is available via the dbExpress components.
ODBC is simply another (slow) system stuck on top of an already slow BDE. The BDE also has numerous bugs in it and Borland have stopped supporting it - it is possible that one of those bugs is causing your problem. (The BDE is also well known for using internal Paradox type tables to fetch all the results over from the server rather than doing some form of Client-Server stuff- beware.
I use the NCOCI8 components for direct Oracle access from Delphi/BCB to Oracle but they are a bit flakey in the record locking department when using multiple users. However, I'm looking more and more at the dbExpress stuff in BCB 6 Pro for all future use.
Cheers,
Norman.
Tel: 0113 289 6265 Fax: 0113 289 3146 URL: http://www.Lynx-FS.com
-------------------------------------
-----Original Message-----
From: Peter Michelson [mailto:pete77r_at_hotmail.com]
Posted At: Saturday, March 01, 2003 12:43 AM
Posted To: server
Conversation: Mysterious query
Subject: Mysterious query
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 Mon Mar 03 2003 - 04:53:57 CST