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?

[Webinar] Streamline your web hosting managementRegister Today

x
 
kretzschmarConnect With a Mentor Commented:
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
 
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
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
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
All Courses

From novice to tech pro — start learning today.