asked on

Connection to Oracle

How do I make a connection to an Oracle (ver 8) DataBase (UNIX-server) from my Delphi pro (ver 4) application (NT)? I have created an ODBC, which did not succed to connect. (Maybe ODBC isn't the right method to make a connection?)

I have created a Oracle Net 8 service, that succed to connect to the database. I dont know how to use this with my application.

I do not have access to SQL Links because I run Delphi pro (is that right?).

Please help!

Kind Regards/ Henrik

ASKER CERTIFIED SOLUTION

kretzschmar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

swghewc

ASKER

Edited text of question.

mhervais

hi swghewc question of kretzmar make sense because YOU SHOULD BE ABLE to connect.

so it means that something in what you do is missing, and so that we would be able to tell you what, you must tell us what version of delphi you are using, and what you did up to now, to install oracle server and client.

regards, Marc

sburck

An older version of the BDE can cause problems with a lot of Oracle 8 data types (specifically the LOB types), I don't know if it would go as far as to cause a failed connection, though.

CalvinDay

Did you use Oracle Net8 easy Config yet?

CalvinDay

You should first create a SID (make sure you can attach to it) and then that needs to be entered into the ODBC Data Source Service Name.

swghewc

ASKER

Edited text of question.

kretzschmar

hi Henrik,

? just received a notify,
that you've accepted my comment as an answer

is it working now?
what kind was missed, what helped?

meikl