I have a two tier application which is currently under development,
using Oracle8 as the database.  Currently, I'm using BDE.
Should I switch to ADO? (pro/cons)?
Is there any easy way of doing this?
It looks like borland worked hard to make the switch harder for us.  For

example:
  Commit (in TDatabase) vs. CommitTrans (in ADOConection)
  ADOConnections are not visible across forns unless you use the
defining form (unlike TDAtabase, which are global)
  You have to change all Query.FieldByName('mmm').AsInteger to something

else (.Value?) Parameters?
Any more caviates?
Why are the changes?
thanks
avy
P.S.
This was originaly posted in borland.public.delphi.database.desktop.  I
was advised to post it here.  Sorry for the re-post.
avy

[ Attached Message ]

From:	Avy <astromin...@yahoo.com>
To:
Date:	Wed, 27 Dec 2000 19:47:28 +0200
Local:	Wed, Dec 27 2000 12:47 pm
Subject:	BDE SQLlinks vs. ADO

I have a two tier application which is currently under development,
using Oracle8 as the database.  Currently, I'm using BDE.
Should I switch to ADO? (pro/cons)?
Is there any easy way of doing this?
It looks like borland worked hard to make the switch harder for us.  For
example:
  Commit (in TDatabase) vs. CommitTrans (in ADOConection)
  ADOConnections are not visible across forns unless you use the
defining form (unlike TDAtabase, which are global)
  You have to change all Query.FieldByName('mmm').AsInteger to something
else (.Value?) Parameters?
Any more caviates?
Why are the changes?
thanks
avy

Avy,
Whats the need for another attachment? And did you try the remaining
newsgroup -- b.p.d.database.ado :).

-- Reddy Palle.

"Avy" <astromin...@yahoo.com> wrote

Direct Oracle Access will give you the fastest response times.  You don't say
what version of Oracle 8, so I can't be specific about the BDE, which has had
huge problems with O8.  I haven't used ADO myself, but I believe that it
cannot handle O8 BLOBS and  CLOBS (am not certain).  Why make yourself
dependent on another MS product?

John Pierce