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.
LVL 14
systanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
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.

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

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
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

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
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.