Solved

Delphi-Oracle connection

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Array of Key/Value Pairs as input to Oracle function 10 53
Outer Query not returning data - SQL HELP 16 50
history tablespace temp usage 2 31
join 2 views with 5 conditions 3 46
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 …
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

867 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

12 Experts available now in Live!

Get 1:1 Help Now