Current recordset d does not support updating locktype dts
OLE DB goes beyond the capabilities of what is possible with ODBC.
OLE DB provides access to traditional database sources, such as SQL Server, Oracle, Access, and Fox Pro, as well as nondatabase-type applications.
With ADO and IIS 3.0, ASP Web pages could query, update, delete, and manipulate data from any ODBC data source.
ADO 1.5 is available in Internet Explorer 4.0 and IIS 4.0, and it is also available as a stand-alone download known as Microsoft Data Access Components.
It relies on parts of a new database strategy that Microsoft refers to as Universal Data Access (UDA).
To find out if your web browser supports Java Script or to enable Java Script, see web browser help. An SSO account is a single user account used to access content in these OSIsoft websites: Tech Support, Learning and PI Square Community.Unless otherwise specified, this chapter concentrates on core database access capabilities that are available in all versions of ADO. The connection string identifies the data source and can supply optional parameters such as a user ID and a password.These optional parameters depend upon the data source-for example, some data sources may not support a user ID and password.Table 13-1 lists the various ADO versions and the differences among them.If clients on your network are using Internet Explorer and/or Windows 98, they have ADO installed.
Another way that OLE DB differs from ODBC is that OLE DB is implemented as a COM interface.