Page 1 of 1
Settings for TOraSession component
Posted: Thu 16 Jun 2011 07:41
by gia
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]?
Posted: Thu 16 Jun 2011 08:24
by AlexP
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'.
Posted: Thu 16 Jun 2011 10:40
by gia
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?
Posted: Thu 16 Jun 2011 11:18
by AlexP
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.
Posted: Thu 16 Jun 2011 12:23
by gia
Dear AlexP
Thank You very much for help
Posted: Thu 16 Jun 2011 12:32
by AlexP
Hello,
If you have any other questions, feel free to contact us.
Posted: Thu 16 Jun 2011 13:07
by gia
Hello.
Can You tell me how to download and install ODAC help files?
Posted: Fri 17 Jun 2011 07:41
by AlexP
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.