c#中如何用odbc连接vfp

Question

例如：
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDB" %>
<script runat="server" language="C#">
 void Page_Load(object sender, System.EventArgs e){
   string MyConnString = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\productsgood.dbf";
    string strComm = "select * from products";
    OleDbConnection MyConnection = new OleDbConnection(MyConnString);
    OleDbDataAdapter MyComm = new OleDbDataAdapter(strComm,MyConnection);
   DataSet ds=new DataSet();
   MyComm.Fill(ds,"products");
   }
</script>

Answer 1

试试:
"Driver={Microsoft dBASE Driver (*.dbf)};DriverID=277;Dbq=c:\mydbpath;" 

Answer 2

ODBC Driver for Visual FoxPro 
With a database containeroConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
           "SourceType=DBC;" & _
           "SourceDB=c:\somepath\mySourceDb.dbc;" & _
           "Exclusive=No" 
 
Without a database container (Free Table Directory)oConn.Open "Driver={Microsoft Visual FoxPro Driver};" & _
           "SourceType=DBF;" & _
           "SourceDB=c:\somepath\mySourceDbFolder;" & _
           "Exclusive=No" 

Answer 3

更多请参考http://msdn.microsoft.com/library/en-us/odbc/htm/sqlapi.asp