We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you two Citrix podcasts. Learn about 2020 trends and get answers to your biggest Citrix questions!Listen Now

x

Delphi-Oracle connection

marcelh
marcelh asked
on
Medium Priority
892 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
Comment
Watch Question

Commented:
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

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts

Commented:
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.
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.