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
swghewcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kretzschmarCommented:
hi swghewc,

what delphi version do you have (standard-pro-C/S)?
do you have native sql links?
do you have defined an alias for the odbc-driver?
did you have the odbc-driver properly configured?
did you installed the oracle-client software?
did a bde-replacment like
http://www.allroundautomations.nl/doa.html
help?

meikl
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
swghewcAuthor Commented:
Edited text of question.
0
mhervaisCommented:
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
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

sburckCommented:
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.
0
CalvinDayCommented:
Did you use Oracle Net8 easy Config yet?
0
CalvinDayCommented:
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.
0
swghewcAuthor Commented:
Edited text of question.
0
kretzschmarCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Delphi

From novice to tech pro — start learning today.