Solved

delphi7+personal oracle8

Posted on 2004-04-12
3
185 Views
Last Modified: 2012-05-04
Hi, could u tell me what is the best way to connect to oracle database from delphi application.
thanks
0
Comment
Question by:jrzjrz
3 Comments
 
LVL 1

Accepted Solution

by:
choinierep earned 50 total points
ID: 10813786
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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question