Edit

Share via

Provider Support for ADOX (ADO)

  • Article

Certain features of ADOX are unsupported, depending on your OLE DB data provider. ADOX is fully supported with the OLE DB Provider for Microsoft Jet. The unsupported features with the Microsoft OLE DB Provider for SQL Server, the Microsoft OLE DB Provider for ODBC, or the Microsoft OLE DB Provider for Oracle are listed in the following tables. ADOX is not supported by any other Microsoft OLE DB providers.

Microsoft OLE DB Provider for SQL Server

Object or Collection Usage Restriction
Tables collection Properties are read/write prior to object creation, and read-only when referencing an existing object.
Views collection Views is not supported.
Procedures collection The Append and Delete methods are not supported.
Procedure object The Command property is not supported.
Keys collection The Append and Delete methods are not supported.
Users collection Users is not supported.
Groups collection Groups is not supported.

Microsoft OLE DB Provider for ODBC

Object or Collection Usage Restriction
Catalog object The Create method is not supported.
Tables collection The Append and Delete methods are not supported. Properties are read/write prior to object creation, and read-only when referencing an existing object.
Procedures collection The Append and Delete methods are not supported.
Procedure object The Command property is not supported.
Indexes collection The Append and Delete methods are not supported.
Keys collection The Append and Delete methods are not supported.
Users collection Users is not supported.
Groups collection Groups is not supported.

Microsoft OLE DB Provider for Oracle

Object or Collection Usage Restriction
Catalog object The Create method is not supported.
Tables collection The Append and Delete methods are not supported. Properties are read/write prior to object creation, and read-only when referencing an existing object.
Views collection The Append and Delete methods are not supported.
View object The Command property is not supported.
Procedures object The Append and Delete methods are not supported.
Procedure object The Command property is not supported.
Indexes collection The Append and Delete methods are not supported.
Keys collection The Append and Delete methods are not supported.
Users collection Users is not supported.
Groups collection Groups is not supported.