ADO connection string keywords
To specify ActiveX Data
Objects (ADO) connection string keywords, you must specify the keyword
by using the keyword=value format
in the provider (connection) string. You must delimit multiple keywords
with a semicolon (;).
Updatable scrollable cursors in ADO applications
If you want to write
an ADO application that accesses updatable scrollable cursors, you
can set the cursor location to either adUseClient or adUseServer.
If you set the cursor location to adUseServer, the
cursor materializes on the server.
Limitations for ADO applications
ADO applications have
limitations with calling stored procedures, inserting a new row by
using a server-side scrollable cursor, and no support for default
parameter values.