Use the Location parameter in the connection string to specify a remote server.
This second version of the provider did have some drawbacks. It was considered a thick client because the relational engine was encapsulated in the provider. Therefore, the provider had to cross the process boundary for each row, which led to performance issues for applications in a client-server setting.
In order to open a navigational result set, adCmdTableDirect must be used in the options of the Open method. In the previous version,
adCmdTable would successfully open a navigational result set. However, ADO will turn this into a "
SELECT * FROM" SQL statement. This will make the result set command-based, and indexes will be unavailable.
ISequentialStream support has been added to the OLE DB provider. In ADO, this translates into AppendChunk/GetChunk functionality of the recordset object. It also allows complex data binding to transfer BLOB data to and from visual controls.