• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2686
  • Last Modified:

Lazarus Oracle vs Delphi Oracle

I used <oci.dll> for connecting Lazarus and Oracle
http://download.oracle.com/otn/other/ole-oo4o/ODAC1110621Xcopy.zip

How can I do that in Delphi?
Any idea?


I don't want to use devArt interface.
0
systan
Asked:
systan
  • 3
  • 3
2 Solutions
 
Geert GOracle dbaCommented:
oci is the oracle client interface

install the oracle client on your pc, check the runtime client in the oui
and when you use a query it will use the oci
0
 
systanAuthor Commented:
yes Geert I know that already, what I am trying to say is,  can I use oci.dll as the dbExpress driver for Oracle connection?

Because in Lazarus I only need the oci.dll then automate the connection to oracle dB server.


thanks
0
 
Geert GOracle dbaCommented:
guess it depends on oracle client installed and delphi version
i have oracle 11.2.0.2 installed, the runtime version > oci

i got Borland.Data.TDBXError: ORA-12546: TNS: toegang is geweigerd.

opening data explorer > choose oracle connection and modify it
hmmm, my oracle listener log file is a little big atm ... 1.4G
i'll try and find why this is givin an issue for me
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
systanAuthor Commented:
>>guess it depends on oracle client installed and delphi version
ok,
do I need the odac from devArt/dBexpress?,   just to get connected to the oracle database server?
or really I need to install the whole oracle client?

Because in Lazarus i ONLY need the "oci.dll" then automate the connection to oracle dB server USING Lazarus sqldB component palette.


thanks
0
 
jimyXCommented:
If you do not want to use DevArt, you may have a look at this:
http://allroundautomations.com/

BTW what about ADO, did you try it?
I do not have Oracle installed so when I attempt to configure the ADO to connect to a server and I press "Test Connection" I get this message but I am not sure if that oci.dll will fix it, so if you have Oracle at hand you may test and confirm.
ADO-Oracle-connect.JPG
0
 
systanAuthor Commented:
I'm sorry, because of my laziness we have not much understand what I am really asking.   I'm very modest and lazy.   I got to get out from this habit,  excuse me.

thanks for the time
0
 
Geert GOracle dbaCommented:
when you install oracle client with the oracle universal installer
you have different options

instant client
runtime client
admin client
custom

you could try custom and select only the oracle client interface and see where you come out

this depends purely on what you need
if you use odbc, then you need the windows components in the custom client ...
you can select every option if you choose custom
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now