Solved

Oracle and TQueries

Posted on 2006-11-03
2
248 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:
mnasman 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

17 Experts available now in Live!

Get 1:1 Help Now