Re: Create access database on run time

From: DRS (drs_at_removethis.ihug.com.au)
Date: 12/05/03 

Date: Fri, 5 Dec 2003 23:29:44 +1100

Brian Bushay TeamB <BBushay@Nmpls.com> wrote in message
64tvsvsecpbdtiofqbp4n8htal5a9vr255@4ax.com
>> thanks your reply, but what is ADOX type library ?
>> usually i use ADODB only, are they same ?
> They are not the same. ADOX is an extension of ADO that microsoft
> provides but as far as I know It is only implemented for the Jet 4
> provider.

This has been discussed before. 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. 

-- 
 A: Top-posters.
 Q: What is the most annoying thing on Usenet?

Relevant Pages

  • Error 80040e14
    ... I have a simple Stored Procedure and all it does is it adds 4 ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.programming)
  • VSS Errors using NTBackup
    ... Microsoft OLE DB Provider for SQL Server ... Error message: ...
    (microsoft.public.windows.server.sbs)
  • Re: linked tables
    ... > Microsoft OLE DB Provider for ODBC Drivers ... then access the Jet table with a 4-part name ... provider, instead of the one for Jet. ... table defined in the Access database which is linked to a SQL Server ...
    (microsoft.public.vb.database.ado)
  • Re: Oracle & SQL Server
    ... > Then consider to create Views to make it easy to access the remote Oracle ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.server)
  • Re: Oracle & SQL Server
    ... > Then consider to create Views to make it easy to access the remote Oracle ... Microsoft OLE DB Provider for SQL Server ...
    (microsoft.public.sqlserver.programming)