title: C# VFP OLEDB connection string problems (DBF and CDX vs DBF and IDX)
body: <p>I've connected to foxpro databases before, but only ones that have both a .dbf and .idx file.  </p>
  
  <p>I register the Microsoft Ole DB Provider for Visual Foxpro 7.0 and use the following type of code:</p>
  
  <pre><code>  string sqlSTR = "SELECT * FROM TableName";
    string strConnect = @"Provider=VFPOLEDB.1;Data Source=C:\Stuff.dbf;Extended Properties=dBASE IV;"
  </code></pre>
  
  <p>And open the connection.  This file, though, has a .dbf and .cdx file (which, reading online seems to be the structure of the database).  When I use the connection string above and the following code:</p>
  
  <pre><code>OleDbConnection myConn = new OleDbConnection(strConnect);
  myConn.Open()
  </code></pre>
  
  <p>It doesn't error or anything, but the execution of the program hangs here.  I have several other parts of the same program that are connecting to files with a dbf + idx file present (not cdx).  What am I doing wrong that I need to correct?</p>
  
  <p>I use the sqlSTR for later operations using a data adapter btw.</p>