Click here to Skip to main content
15,867,453 members
Articles / Programming Languages / C++

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

Rate me:
Please Sign up or sign in to vote.
1.35/5 (6 votes)
16 Jun 2006CPOL 35.1K   17   1
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:

C++
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)


Written By
Web Developer
China China
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

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

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

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