MFC and ODBC connectivity

Hi,

For my project i need some sample codings for connecting Access database using VC++. I used a dialog based project and i dont know how to access the recordset. Pls help me friends. ur suggestions are valuable......




Answer this question

MFC and ODBC connectivity

  • chinimimita

  • Absolute_Zero

    maan!, I think you are using something from the cave age, why not using ADO (ActiveX Data Objects) and OleDb providers (MSJet 4.0 provider) to connect your Access database

    There is still some support for ODBC but why not using better tools available and free!!

    You can import all you need to use ADO directly inside you MFC project, just add in your stdafx.h file the following lines and you will get access to ADO (check you are using the latest version of ADO).

    #import <msado15.dll> \
    no_namespace rename("EOF", "EndOfFile") rename("BOF", "BeginOfFile")

    msado15.dll is usually located in "boot partition drive:\Program Files\Common Files\System\ado", so make this path available from your solution or place the entire path in the #import directive.

    To use the imported set of smart pointers (wrappers) and definitions, you don't need any COM knowledge (if you use only smart pointers, those types that end with Ptr).

    =)



  • MFC and ODBC connectivity