Susan Harkins
harkinsss at bellsouth.net
Thu Mar 9 18:21:28 CST 2006
Yeah -- I saw this last night, but thank you for helping. :) Susan H. There are limits on what can be done with ADOX with SQL Server as opposed to Jet through OLEDB provider. To get around these limits use a different tool SQL-DMO or the newer one for SQL Express SQL-SMO 'This is what the Documentation says... 'Provider Support for ADOX 'Certain features of ADOX are unsupported, depending upon 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 below. 'ADOX is not supported by any other Microsoft OLE DB providers. 'Microsoft OLE DB Provider for SQL Server 'Object or Collection Usage Restriction 'Catalog object The Create method is not supported. '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. Susan Harkins wrote: >Anybody here familiar with using ADOX and SQL Server and have some free >time today? I need help completing an article -- all I would need is a >few snippets of generic code -- but I need them today. Specifically, >I'd like an example of appending a column to an existing table or >appending a new table to a database. Also, I'd like a security example >-- not as specific on it -- could be as simple as appending a new user to an existing group. > >Susan H. > > > -- Marty Connelly Victoria, B.C. Canada _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 268.2.1/277 - Release Date: 3/8/2006