DdfPath can take any of the following forms (discussed below)
Traditional driver-letter nomenclature (c:\path\datafile) are accepted by the
DdfPath property, as in previous versions of the ActiveX. If the drive cannot be located, the VAccess will look for a file called IDSHOSTS using the path environment setting (this file may be used to map drive letters to network or IP addresses, much like LMHOSTS. For more information, see
Pervasive PSQL Programmer's Guide). If this file can be found, it will be searched for the requested path. If the requested path is mapped, the VAccess control will attempt to connect to an IDS at the specified location.
A URL may also be used to specify location. The protocol-specific prefixes are pids for remote (IDS) calls and
pmke for local. Thus, a local call would take the form
pmke://{server}/[path/.../][tablename] and a remote call would appear
pids://{server}/[path/.../][tablename].
UNC (\\server\path\datafile) can be used as a
DdfPath entry as well, where the server can be either a Pervasive PSQL server on the LAN, an IDS server or a server mapped in IDSHOSTS to an IDS server. If the server is not a standard IP address or domain name, the VAccess will attempt to resolve the server name locally. If the location is not available locally, the VAccess will then try to resolve the server name using IDSHOSTS and if successful will re-route calls to the IDS.
As described above, DdfPath can be used to specify local or remote access (see also
Pervasive PSQL Programmer's Guide). However, if remote access is requested, the VAccess will not attempt to connect to the IDS unless
HostConnect is set to
True. Additionally, the
DdfPath and
Location properties cannot attempt to access two different IDS servers simultaneously.
Therefore, if Location is set to a remote location &
DdfPath is set to a different remote location, the server name will be changed in the
Location property to reflect the new remote location specified by
DdfPath. If
Location is set to a local directory,
DdfPath will not affect Location.
If HostAddress is set to specify a server using URIs,
DdfPath will be ignored.
Affects: Location, GetTableList, IndexList, FieldList
Affected by: RefreshLocations, HostAddress, HostConnect, OnRemote event