Re: Choosing Class Problem CDatabase OR CDaoDatabase

From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 04/10/04


Date: Sat, 10 Apr 2004 11:06:57 -0400

Alan

The CDatabase/CRecordset class is for use with any database that has an ODBC
provider. There are ODBC drivers for most mainstream database providers,
especially SQL Server, Oracle, MS Jet, MySql, FoxPro, etc.

The CDaoDatabase/CDaoRecordset is a wrapper for the DAO interfaces, and
works ONLY with the Microsoft Jet Database Engine (i.e. MS Access).

regards
roy fine

"alan" <cheung_yuklun@i-cable.com> wrote in message
news:7bd5ab13.0404100116.2f02d95@posting.google.com...
> Hi All,
>
> I would like to know if I want to connect to MS SQL server, which
> class is most suitable ? CDatabase or CDaoDatabase?
>
> what is the difference between these two classes?
>
> Please advice.
> Thank you very much.
>
> Alan



Relevant Pages

  • Re: Windows Services and SQL Server
    ... I am trying to access my SQL Server 2005 database with a windows service, ... authenticate using the machine account with a $ appended on the network. ... Why using legacy ODBC drivers when there are managed stacks available for most DB's systems on the market? ...
    (microsoft.public.dotnet.languages.csharp)
  • ODBC, SQL Server, "FOR XML" & Cursors error
    ... ODBC drivers (Driver version: 03.81.9030, ... to connect to a SQL Server 2000 database and passing in a ... Server]The FOR XML clause is not allowed in a CURSOR ...
    (microsoft.public.data.odbc)
  • Connecting to MS Sql Server Compact 3.5
    ... This may be a stupid newbie question, but I hope someone can point me in the right direction. ... I have a database created with MS SQL Server Compact Edition 3.5 that I wish to access from VFP. ... My understanding is that there are no ODBC drivers for 3.5, so does anyone have a good idea on what is the best way of accessing it. ...
    (microsoft.public.fox.helpwanted)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)