Progress DataDirect for ODBC for Microsoft SQL Server Wire Protocol Driver User's Guide Release 8.0.2

Host Name

Save PDF

Save PDF

HostName (HOST)

The name, IP address, or alias of the server or instance to which you want to connect.

where:

alias_name: is the alternate name of the server to which you want to connect. When specifying an alias name, the driver uses the server name and port number value provided by the alias for the connection. Aliases are created using the SQL Server Configuration Manager. Note that aliases are supported only on Windows platforms.
IP_address: is the IP address of the server to which you want to connect. Specify this address as: IP_address. For example, you can enter 199.226.224.34.
The IP address can be specified in either IPv4 or IPv6 format. See "Using IP addresses" for details about these formats.
named_server: is the named server address of the server to which you want to connect. Specify this address as: named_server. For example, you can enter SSserver.
named_instance: is a named instance of Microsoft SQL Server, Windows Azure SQL Database, Microsoft Azure Synapse Analytics, or Microsoft Analytics Platform System. Specify this address as: server_name\instance_name.
virtual_network_name: is the virtual network name (VNN) of the availability group listener when using an Always On Availability Group.

For Microsoft Azure Synapse Analytics and Microsoft Analytics Platform System (APS), specifying an IP address for the server is not supported. You must provide a named server to connect.
When an alias name is specified with this option, port numbers settings provided by the alias take precedence over the value of the Port Number (PortNumber) connection option.
If only a server name is specified with no instance name, the driver uses the default instance on the server.
If only a server name is specified with a backward slash \ or \* at the end with no instance name, the driver uses the first instance on the server with a TCP port.

None