Click here to Skip to main content
Click here to Skip to main content

Using ADO to connect to a Visual FoxPro (dbf) table in C++

, 16 Jun 2006
Rate this:
Please Sign up or sign in to vote.
This is a simple sample showing how to get a database connection using ADO to connect a dbf table.

Introduction

This snippet shows how to connect a Visual Foxpro dbf table and get the field names of the table. It comes from another application in which there should be a database connection interface. And the following is the test function for the interface and it works.

As we know dbf tables are stored independently in some file in the disk, not like a .mdb database whose tables can not be seen at the location the database is via Explorer. So when connecting, the file storing the dbf can be regarded as a database. The function below implements the connection:

void CTttView::OnTest() 
{
   _ConnectionPtr m_pCon;
   _RecordsetPtr m_pRecordset;

   AfxOleInit();

   m_pCon.CreateInstance(__uuidof(Connection));

   HRESULT hr;
   try
   {
      //The SourceDB should be a proper directory
      hr=m_pCon->Open("Driver={Microsoft Visual FoxPro Driver}; SourceType=DBF; "
                      "SourceDB=E:\\c program;", "","",adModeUnknown); 
   }
   catch(_com_error e)
   {
      AfxMessageBox("Connection failed, check the direction!");
   } 

   m_pRecordset.CreateInstance(__uuidof(Recordset));
   m_pRecordset->Open("SELECT * FROM Table1", //Table1 is a dbf table name
   m_pCon.GetInterfacePtr(),  adOpenDynamic, adLockOptimistic, adCmdText);

   FieldsPtr pFD=m_pRecordset->GetFields();

   _variant_t index;
   index.vt = VT_I2;
   for(int i=0;i<(int)pFD->GetCount();i++)
   {
      index.iVal=i;
      CString str;
      str.Format("Field: %s" ,(LPCSTR)pFD->GetItem(index)->GetName());
      MessageBox(str);
   }

   m_pRecordset->Close();
   m_pCon->Close();
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

zhipeng0117
Web Developer
China China
No Biography provided

Comments and Discussions

 
GeneralFinding the Columns in an Index PinmemberAlexEvans12-Oct-06 21:28 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140821.2 | Last Updated 17 Jun 2006
Article Copyright 2006 by zhipeng0117
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid