连接Visual Foxpro方法,连接后和操作SQL server数据库一样操作。
Visual FoxPro
OLE DB, OleDbConnection (.NET)
Database container (.DBC):"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine" Free table directory:"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general" Force the provider to use an ODBC DSN:""Provider=vfpoledb.1;DSN=MyDSN""
Read more (Microsoft msdn) >>
ODBC
Database container (.DBC):"Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO" Free Table directory:"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO"
"Collate=Machine" is the default setting, for other settings check the list of supported collating sequences >>Microsoft Visual Foxpro site: http://msdn.microsoft.com/vfoxpro
Visual FoxPro
OLE DB, OleDbConnection (.NET)
Database container (.DBC):"Provider=vfpoledb.1;Data Source=C:\MyDbFolder\MyDbContainer.dbc;Collating Sequence=machine" Free table directory:"Provider=vfpoledb.1;Data Source=C:\MyDataDirectory\;Collating Sequence=general" Force the provider to use an ODBC DSN:""Provider=vfpoledb.1;DSN=MyDSN""
Read more (Microsoft msdn) >>
ODBC
Database container (.DBC):"Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\myvfpdb.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO" Free Table directory:"Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\myvfpdbfolder;Exclusive=No;Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO"
"Collate=Machine" is the default setting, for other settings check the list of supported collating sequences >>Microsoft Visual Foxpro site: http://msdn.microsoft.com/vfoxpro
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货