Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Mysterious query

Mysterious query

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 3 Mar 2003 10:53:57 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7035F4CFC@lnewton.leeds.lfs.co.uk>


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.



Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk
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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US