Solved

Delphi-Oracle connection

Posted on 1997-11-24
2
852 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

730 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