Solved

delphi7+personal oracle8

Posted on 2004-04-12
3
168 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
strCopies  challenge 17 82
python sqlite question 11 46
I need an assist with a programming logic math question. 5 55
MacOS and programming in React 7 28
A short article about a problem I had getting the GPS LocationListener working.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …

910 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now