Provider Support for ADOX
Microsoft ActiveX Data Objects Extensions for Data Definition Language and Security (ADOX) is an extension to the ADO objects and programming model. ADOX includes objects for schema creation and modification, as well as security.
The Microsoft OLE DB Provider for SQL Server (SQLOLEDB) and the Microsoft OLE DB Provider for ODBC (MSDASQL) support most ADOX features. However support for some features is restricted or unavailable.
Restrictions on SQLOLEDB support for ADOX
| Object or Collection |
Usage Restriction |
| Catalog object |
The Create method is not supported. |
| Table object |
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. |
Restrictions on MSDASQL support for ADOX
| Object or Collection |
Usage Restriction |
| Catalog object |
The Create method is not supported. |
| Table object |
Properties are read/write prior to object creation, and read-only when referencing an existing object. |
| Tables collection |
The Append and Delete methods are not supported. |
| 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. |