Solved

Delphi-Oracle connection

Posted on 1997-11-24
2
853 Views
Last Modified: 2010-05-18
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
0
Comment
Question by:marcelh
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 3

Accepted Solution

by:
poncejua earned 50 total points
ID: 1080972
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
 
LVL 3

Expert Comment

by:altena
ID: 1080973
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

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

729 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