• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

delphi7+personal oracle8

Hi, could u tell me what is the best way to connect to oracle database from delphi application.
thanks
0
jrzjrz
Asked:
jrzjrz
1 Solution
 
choinierepCommented:
With Oracle 8 you have several options.

Options that come with Delphi:
-----------------------------------
1. BDE:  I find it somewhat slow compared to other solutions that come with Delphi, but reliable.  (Note: Borland has discontinued BDE)
2. dbExpress:  This is very fast.  (Note: the dbExpress driver is some what buggy.  I would purchase a replacement driver from Corelabs (http://crlab.com/dbx/))
3. ADO:  I find this one also slow (slower then BDE), but reliable.  Make sure you have the lastest drivers from Microsoft.  (http://msdn.microsoft.com/data/Default.aspx    Look for MDAC downloads)  


Options that you must purchase:
-------------------------------------
There are a lot of options here.  I use the dbExpress driver from Corelabs (http://crlab.com/dbx/), because I use multiple database and don't what to lock myself into oracle only.  If you don't care about locking yourself in then take a look at Oracle Data Access Components from Corelabs (http://crlab.com/odac/).  I would say this is the best method of accessing Oracle hands down. It is the fastest options and takes advantage of all of Oracles features.   I have not used any other options, but you can look at this site for more info about other options.(http://www.kylecordes.com/bag/listbytype.html)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now