• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

databases in MFC

What are the sequence of actions to connect to an access database through MFC?
0
andrewS
Asked:
andrewS
1 Solution
 
trestanCommented:
There are several ways to do it, either ODBC or DAO. I list the online help topics for you. There are also example codes associated with the instructions. You can get an easy start with them.
ODBC:
Visual C++ -> Microsoft Foundation Class Reference -> MFC tchnical Notes -> TN068:...
DAO:
Visual C++ -> Visual C++ Programmer's Guide -> Adding Program Functionality -> Details -> Database Topics (DAO) -> DAO Workspace...
General:
Visual C++ -> Visual C++ Programmer's Guide -> Adding Program Functionality -> MFC Topics (General) -> Building on the Framework -> Sequence of Operations for Creating Database Applications.
Which to choose:
"If you’re using mostly desktop data, we encourage you to consider the MFC
DAO database classes, because you’ll find them to be efficient and powerful.
If you primarily use ODBC server-based data, your project may function more
efficiently with the ODBC-based classes.
Other considerations include the kind of network you have, the scalability
requirements, and whether speed is more important than anything else. The
best thing to do is to prototype applications using the set of database
classes you think will work best. Do some benchmarking to determine your
best performance options.The decision is really up to you."

0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now