ODAC

TOraSession.Server Property

Contains the server name.

Class

TOraSession

Syntax

property Server: string;

Remarks

Use the Server property to supply server name to handle server's request for a login.

Formatting of this property is different and depends on the value of Options.Direct property:

If Options. Direct is set to False, Server assumes TNS alias name for the requested database or an EZCONNECT connection string.

If Options.Direct is True, Server accepts a string holding three fields separated by a colon. If Oracle servers has SID is equal to Service Name then string is the following: "Host:Port:SID". If Oracle Server has SID differ from Service Name then string is the following: "Host:Port:sid=SID" for connection using SID and "Host:Port:sn=Service Name" for connection using Service Name. Here Host is an IP address of the server that hosts the database, Port is a port number that server listens, SID is a system identifier that specifies an Oracle database instance name, and Service Name is a system alias to an Oracle database instance (or many instances).

Note: EZCONNECT connection string format is supported in Direct Mode as well.

Note: If prefixes sid= or sn= aren't set, then connection will be established using SID.

See Also

© 1997-2022 Devart. All Rights Reserved. Request Support DAC Forum Provide Feedback