Improve company productivity with a Business Account.Sign Up

x
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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