Solved

databases in MFC

Posted on 1998-07-21
1
262 Views
Last Modified: 2013-11-25
What are the sequence of actions to connect to an access database through MFC?
0
Comment
Question by:andrewS
1 Comment
 
LVL 8

Accepted Solution

by:
trestan earned 200 total points
ID: 1319476
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
modThree challenge 4 79
Modbus - whats the maximum I can store in one register? 4 78
Detect file exist or not 3 133
Is there a simple front-end menu system. 9 71
For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
This video will show you how to get GIT to work in Eclipse.   It will walk you through how to install the EGit plugin in eclipse and how to checkout an existing repository.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now