Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

CDatabase with Foxpro

Posted on 2000-03-30
2
331 Views
Last Modified: 2013-11-20
I using VC++ to program database.
How to Using CDatabase to link with dbf
file(foxpro driver).
I don't want to config it in ODBC control panel.
I want to program it in the project.
0
Comment
Question by:zhangguangcheng
2 Comments
 
LVL 4

Accepted Solution

by:
inpras earned 100 total points
ID: 2671835
if U want to configure ODBC dynamically then use SQLConfigDataSource(...); with DSN as directory containing .dbf files..

Foxpro doesn't have any thing as database so U have to take UR entire directory of .dbf files as database and each .dbf file as recordset..

Hope this helps
inpras
0
 

Expert Comment

by:ycl
ID: 2672127
Simple way:

CDatabase m_DB;
CString m_strFilePath=_T("c:\Mydbpath");

                  CString strDsn=_T("driver={Microsoft Visual Foxpro Driver};BackgroundFetch=Yes;SourceType=DBF;Exclusive=NO;SourceDB=");
                  strDsn+=m_strFilePath;
                  m_DB.OpenEx(strDsn, CDatabase::noOdbcDialog);
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Adapt this command to show who installed 29 111
has77  challenge 9 88
wordappend challenge 8 199
moto 4g phone enable finger print 4 26
This is to be the first in a series of articles demonstrating the development of a complete windows based application using the MFC classes.  I’ll try to keep each article focused on one (or a couple) of the tasks that one may meet.   Introductio…
Introduction: Dialogs (2) modeless dialog and a worker thread.  Handling data shared between threads.  Recursive functions. Continuing from the tenth article about sudoku.   Last article we worked with a modal dialog to help maintain informat…
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.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

809 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