Delphi-Oracle connection

Is there a short, fast,  save and simple way to connect delphi c/s suite to an oracle database, and if so, how to establish this link......?  Which tools to use, and which essential parts do i need?
thanks
Marcel
marcelhAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

poncejuaCommented:
Hi Marcel,

First of all, let me tell you that I don't know what OS platform do you have. That implies I can't define you all the steps in order to configure the oracle side. Also you don't tell what oracle version do you have (if you have a 7.1 version you must use the ORAxx71.dll or the ORAxx73.dll for the 7.3 version). Do you have a IPX/SPX based network or a TCP/IP one ?

Nevertheless, in the oracle side, you must to create an instance and set the connectivity by adding the parameters in the listener.ora and tnsnames.ora files (located in the server, also you have some examples inside them to configure your instance).

In the client side (Delphi side), you must to configure the ODBC connectivity with the ODBC Administrator provided with the Delphi Software. There you must indicate the name of your database and the protocol that you're using. Also you have some examples where you can find a way to configure your instance.

Probably the answer is not complete because I need more information in order to give you a full solution.

I proposed you to write me directly to my e-mail address: jmponcemartinez@hotmail.com. I think that I could help you faster to solve your problem.

I hope this helps you. Please, do not hesitate to contact me !!!

Regards,

Juan Manuel Ponce Martinez
DBA - Bridas S.A.P.I.C.
Buenos Aires - Argentina
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
altenaCommented:
Hi Marcel,

One of the reasons to buy the Delphi C/S suite is to use
it's "SQL-links". These alllow you to connect to Oracle
"short, fast, save and simple "

(and these are why the C/S suite costs big $$$)

I hope Juan is  not upset over this, but I think ODBC is
not the way to go once you have the Delphi C/S suite.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.