With ADO 2.5, an absolute URL may also define a context. That is, the connection defines the context for subsequent operations. One function of an open connection, represented by a Connection object, is to restrict subsequent operations to the data source represented by that connection.

For information about the schemes registered by your provider, see your provider documentation. ADO assumes all URLs prefixed with 'http' represent web folders or files to be used with the Internet Publishing Provider. For example, the http scheme is registered to the Microsoft OLE DB Provider for Internet Publishing. This means that any URLs using this scheme will automatically invoke the registered provider. If a provider supports URLs, it will register for one or more URL schemes. A relative URL typically consists only of the path, and optionally, the resource, but no scheme or server. In effect, the 'complete URL' of the target is specified by concatenating the absolute and relative URLs. It may be a simple file, containing a single binary stream of bytes, or a structured document, containing one or more storages and binary streams of bytes.Īn absolute URL contains all the information necessary to locate a resource.Ī relative URL locates a resource using an absolute URL as a starting point. If included, resource is the target, and is typically the name of a file. If resource is omitted, the target is the last directory in path. Specifies the sequence of directories leading to the target. Specifies the name of the computer where the resource is located. Specifies how the resource is to be accessed.

In this discussion, an absolute URL is of the form: A URL specifies the location of a target stored on a local or networked computer, such as a file, directory, HTML page, image, program, and so on.

Excel relative vs absolute reference