Settings for TOraSession component

gia · Post by **gia** » Thu 16 Jun 2011 07:41

Dear AlexP,

can You explain more detail how must I set TOraSession.Server property?
Now it looks so:
OraSession1.Server=bcc
where bcc is the name of ORACLE database.
Please explain where must I get values for HOST, PORT and SN and which must by syntax for this property?
OraSession1.Server=[syntax of value]?

AlexP · Post by **AlexP** » Thu 16 Jun 2011 08:24

Hello,

To work with Oracle without installing additional software (Oracle client), you should use the Direct mode.
For this you should set the TOraSession.Options.Direct property to True, and the TOraSession.Server preoperty like 'HOST:PORT:SID' or 'HOST:PORT:SN=SERVICE_NAME'.

gia · Post by **gia** » Thu 16 Jun 2011 10:40

AlexP wrote:Hello,

To work with Oracle without installing additional software (Oracle client), you should use the Direct mode.
For this you should set the TOraSession.Options.Direct property to True, and the TOraSession.Server preoperty like 'HOST:PORT:SID' or 'HOST:PORT:SN=SERVICE_NAME'.

Can You explain more detail the syntax of Server property?

AlexP · Post by **AlexP** » Thu 16 Jun 2011 11:18

Hello,

Here is a description of the Server property for connecting in the Direct mode:

TOraSession.Server := 'Host:Port:sid=SID'; - for connection with using SID
TOraSession.Server := 'Host:Port:sn=ServiceName'; - for connection with using Service Name.

Where

Host is the server's IP address or DNS name.
Port is the port number that the server listens to.
SID is a system identifier that specifies an Oracle database instance name.
ServiceName is a system alias to an Oracle database instance (or many instances).

You can find more detailed information in the ODAC help, the Connecting in Direct Mode topic.

gia · Post by **gia** » Thu 16 Jun 2011 12:23

Dear AlexP

Thank You very much for help

AlexP · Post by **AlexP** » Thu 16 Jun 2011 12:32

Hello,

If you have any other questions, feel free to contact us.

gia · Post by **gia** » Thu 16 Jun 2011 13:07

Hello.

Can You tell me how to download and install ODAC help files?

AlexP · Post by **AlexP** » Fri 17 Jun 2011 07:41

Hello,

You can download the help file in the chm format at http://www.devart.com/odac/odacchm.zip .

Help file in the Windows help format is installed automatically when ODAC is installed if you did not uncheck this option and you already have Delphi help installed. Help in the Windows help format is installed for Delphi 2005 and higher. For earlier Delphi versions help in the CHM format is supplied with ODAC.