D.9 HS_FDS_CONNECT_INFO
HS_FDS_CONNECT_INFO
initialization parameter for Oracle Database Gateway for SQL Server.
Property | Description |
---|---|
Default Value |
None |
Range of Values |
Not applicable |
HS_FDS_CONNECT_INFO
that describes the connection to the non-Oracle system.
The default initialization parameter file already has an entry for this parameter. The syntax for HS_FDS_CONNECT_INFO
for the gateway is as follows:
For UNIX:
HS_FDS_CONNECT_INFO=host_name[[:port_number]|/[instance_name]][/database_name]
where, host_name
is the host name or IP address of the machine hosting the SQL Server database, port_number
is the port number of the SQL Server, instance_name
is the instance of SQL Server running on the machine, and database_name
is the SQL Server database name.
Either of the variables port_number
or instance_name
can be used, but not both together. Optionally, they both can be omitted. The variable database_name
is always optional. The slash (/
) is required when a particular value is omitted. For example, all of the following entries are valid:
HS_FDS_CONNECT_INFO=host_name/instance_name/database_name HS_FDS_CONNECT_INFO=host_name//database_name HS_FDS_CONNECT_INFO=host_name:port_name//database_name HS_FDS_CONNECT_INFO=host_name/instance_name HS_FDS_CONNECT_INFO=host_name
For Windows:
HS_FDS_CONNECT_INFO= host_name/[instance_name][/database_name]
where, host_name
is the host name or IP address of the machine hosting the SQL Server database, instance_name
is the instance of SQL Server running on the machine, and database_name
is the SQL Server database name.
Both instance_name
and database_name
are optional. If instance_name
is omitted and database_name
is provided, the slash (/
) is required. This can be shown as follows:
HS_FDS_CONNECT_INFO= host_name//database_name
This release supports IPv6 format, so you can enter IPv6 format in place of hostname
, but you need to wrap square brackets around the IPv6 specification.
For example:
HS_FDS_CONNECT_INFO=[2001:0db8:20c:f1ff:fec6:38af]:port_number/…
Parent topic: Initialization Parameters