Is there a need to install oracle client on the client machine?

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
softdestek
Posts: 7
Joined: Tue 01 May 2012 06:57

Is there a need to install oracle client on the client machine?

Post by softdestek » Sun 08 Mar 2015 16:46

Is there a need to install oracle client on the client machine?

Can be connected directly without installing anything oracle?with odac components.

Do I need the following...
Thanks
----------------------------------
http://www.oracle.com/technetwork/topic ... 85727.html


Instant Client Downloads
for Microsoft Windows (32-bit)
http://download.oracle.com/otn/nt/insta ... .0.2.0.zip

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: Is there a need to install oracle client on the client machine?

Post by AlexP » Tue 10 Mar 2015 06:27

Hello,

ODAC supports 2 work modes: OCI - Oracle Client is used, and Direct - direct connection via TCP/IP.
To use the Direct mode, you should specify host, port and SID/Service Name in the connection string, for example:

Code: Select all

OraSession1.ConnectString := 'login/passwd@host:port:sid'
You can find more detailed information in the documentation: http://www.devart.com/odac/docs/work_net.htm .

Post Reply