Solved

Oracle and TQueries

Posted on 2006-11-03
2
252 Views
Last Modified: 2010-04-05
Hello !

What's the best way to use Delphi / C++Builder TQueries' with Oracle 8 server ?

We use a BDS 2006 trial and C++Builder 5 Pro.

Thanks !
0
Comment
Question by:mychel_normandeau
2 Comments
 
LVL 12

Assisted Solution

by:Ivanov_G
Ivanov_G earned 62 total points
ID: 17871272
In most cases the best way is to user DAO (Direct Access Objects) like this one: http://crlab.com/odac/

You can also use ADO or BDE. They are DB independent. You can prepare a DB on different than Oracle server and use the same code (not always).

If you want to use the best Oracle can give you - use DAO.
0
 
LVL 22

Accepted Solution

by:
Mohammed Nasman earned 63 total points
ID: 17872567
BDS2006 has different way to connect to oracle

1. BDE with sql links (not recommanded, and support oracle 8i and below only)
2. ODBC using BDE components or third party ODBC components.
3. ADO (Good one)
4. dbExpress(may be the best option with BDS)
5. Free third party like: Zeos, AnyDac(support Direct access to oracle , sql server and more)
5. third party components (commercial) for direct access component(DOA, ODAC)

I don't know if C++Builder pro 5 support ADO or not, if you use C++builder only you can buy Turbo C++, which will cost you less than BDS 2006

also try to download trubo delphi , I didn't try the free version, but it has ADO components, so it may be fit your needs
http://www.turboexplorer.com
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

756 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