Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C / C++ / MFC
  4. Dao DB

Dao DB

Scheduled Pinned Locked Moved C / C++ / MFC
c++databaseperformancequestion
5 Posts 4 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • R Offline
    R Offline
    rfraser
    wrote on last edited by
    #1

    I'm using vc++ 6.0,MFC and the CDao classes to open up access databases because of the better performance over ODBC. But when I try to open an Access 2000 db, it can't do it. I assume this is because the Jet engine it is using is 3.x. Is there a way to set which jet engine is used??? Thanks

    R G 2 Replies Last reply
    0
    • R rfraser

      I'm using vc++ 6.0,MFC and the CDao classes to open up access databases because of the better performance over ODBC. But when I try to open an Access 2000 db, it can't do it. I assume this is because the Jet engine it is using is 3.x. Is there a way to set which jet engine is used??? Thanks

      R Offline
      R Offline
      RChin
      wrote on last edited by
      #2

      rfraser wrote: Is there a way to set which jet engine is used??? Yes there is. This is a known MFC bug. The workaround is discussed Here[^]


      I Dream of Absolute Zero

      1 Reply Last reply
      0
      • R rfraser

        I'm using vc++ 6.0,MFC and the CDao classes to open up access databases because of the better performance over ODBC. But when I try to open an Access 2000 db, it can't do it. I assume this is because the Jet engine it is using is 3.x. Is there a way to set which jet engine is used??? Thanks

        G Offline
        G Offline
        GeMe_Hendrix
        wrote on last edited by
        #3

        Please note that Microsoft really are trying to kill off DAO. If you want to future proof your application I would reccommend switching to ADO (there are some C++ wrapper classes for this).

        R C 2 Replies Last reply
        0
        • G GeMe_Hendrix

          Please note that Microsoft really are trying to kill off DAO. If you want to future proof your application I would reccommend switching to ADO (there are some C++ wrapper classes for this).

          R Offline
          R Offline
          RChin
          wrote on last edited by
          #4

          This is true. Although, to be on rfraser's side, DAO *is* much more faster and efficient than ADO due to the fact thats its inherently closer to the native JET engine.
          I have been using ADO, over DAO for a while now and know of its scalability. But the downside is that you lose the data access speed that DAO is so good at.
          Switching to ADO, no matter what the speed depreciation, is the way forward. If I remember correctly, Microsoft has stopped support for the JET engine as of V2.7 of the ADO distribution files. This is to promote the MSDE engine; a localised, 'baby' version of the SQL Server database system.

          My advice is to start out on your db adventure with the CDAO* classes then quickly move on to ADO for real world, scalable applications.


          I Dream of Absolute Zero

          1 Reply Last reply
          0
          • G GeMe_Hendrix

            Please note that Microsoft really are trying to kill off DAO. If you want to future proof your application I would reccommend switching to ADO (there are some C++ wrapper classes for this).

            C Offline
            C Offline
            coralsnake_
            wrote on last edited by
            #5

            Hi , just an question from a novice like me : how to use #import in c programme ? not c++ is there an directive like it for c ? it's for use ADO in a c program thank you Adel that which hesitates is lost. that which hesitates is lost.

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups