Re: Create access database on run time

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

  • Next message: Matthew Noordermeer: "Re: Another connection string question"
    Date: Sun, 7 Dec 2003 02:49:19 +1100
    
    

    Brian Bushay TeamB <BBushay@Nmpls.com> wrote in message
    5ei2tvc8nqmt4u50fn413dbs0ojagfrrbe@4ax.com
    >> 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.
    > That list looks to me like a subset of what is supported with SQL for
    > these providers. Is there anything useful you can do with ADOX that
    > you can't do with SQL? With Jet Oledb driver there are quite a few
    > things you can only do with ADOX

    I'm not as familiar with using ADOX for anything other than Jet. I just
    wanted to correct the mistaken assertion that only Jet supports ADOX. SQL
    Server for example supports most of it.

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

  • Next message: Matthew Noordermeer: "Re: Another connection string question"

    Relevant Pages

    • Re: Create access database on run time
      ... but what is ADOX type library? ... depending upon your OLE DB data provider. ... Microsoft OLE DB Provider for SQL Server, the Microsoft OLE DB Provider for ... Microsoft OLE DB Provider for SQL Server ...
      (borland.public.delphi.database.ado)
    • Re: Create access database on run time
      ... >depending upon your OLE DB data provider. ... ADOX is fully supported with the ... >OLE DB Provider for Microsoft Jet. ... >Microsoft OLE DB Provider for SQL Server, the Microsoft OLE DB Provider for ...
      (borland.public.delphi.database.ado)
    • Re: Question on Posting data in ADODataSet
      ... The OLE DB ... > Provider is "Microsoft OLE DB Provider for ODBC Drivers' I found that ... > The error message is the following: ...
      (borland.public.delphi.database.ado)
    • SQL 2005 and Linked Server for DB2
      ... The SQL2000 use Microsoft OLE DB provider for ODBCthat work fine ... The OLE DB provider "MSDASQL" has not been registered. ... I need some help about real necessity to configure both drives (MSDASQL ...
      (microsoft.public.sqlserver.setup)
    • Re: Authentication methods for connections to SQL Server in ASP Pa
      ... Microsoft OLE DB Provider for SQL Server error '80004005' ... Multiple-step OLE DB operation generated errors. ... These errors are probably because there is no 'Provider' keyword in your ...
      (microsoft.public.sqlserver.security)