HostAddress

Specifies the IP address or domain name of the computer hosting the database to be accessed. The connection is made via a database URI.

Remarks

As is the case with any TCP/IP agent, a domain name can only be resolved if the computer has access to a DNS server. Likewise, use of a domain name results in somewhat slower connection time, as the domain name must be resolved before the connection can be established.

Specify only the IP address or server name. Do not attempt to specify the URI explicitly, or use URI parameters. The ActiveX controls will build the URI when HostAddress and DatabaseName are specified.

This property, like Location and DdfPath, is dependent on the HostConnect property. If HostConnect is True and the value of the HostAddress property is changed, the old connection (if any) will be closed and the new connection will be attempted. When the ActiveX attempts to connect to the server and fails, the HostConnect property is automatically set to False. To make another connection attempt, you must reset HostConnect to True.

HostAddress overrides any server settings in DdfPath and Location.

The default value is blank (empty string).