也请教如何打开FOXPRO数据库(*.DBF)
原因:
在.NET下开发一新系统,由于要实时读取在另一系统的数据库(用FOXPRO2.6开发).
由于本人初次接触ADO编程,请各位高手赐教,并提供例子,谢谢!!
下面给出有关的设定,源码,出错信息:
1.DNS设定
[ODBC]
DRIVER=Microsoft FoxPro VFP Driver (*.dbf)
UID=
Deleted=Yes
Null=Yes
Collate=Machine
BackgroundFetch=Yes
Exclusive=No
SourceType=DBF
SourceDB=d:\EASYDISK\jygl\ZQFD
2.程序块
OleDbConnection foxconnection = new OleDbConnection();
foxconnection.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;DNS=ZQFD;";
OleDbCommand foxcommand= new OleDbCommand();
foxcommand.CommandText="SELECT * FROM WZLB.DBF";
foxcommand.Connection=foxconnection;
foxconnection.Open();
DataSet foxdataset;
foxdataset=new DataSet();
OleDbDataAdapter foxadapter=new OleDbDataAdapter();
foxadapter.Fill(foxdataset,"wzlb.dbf");
4.出错停留在倒数第三行;
5.调试的输出结果:
“DefaultDomain”:已加载“c:\winnt\microsoft.net\framework\v1.0.2914\mscorlib.dll”,未加载符号。
“WindowsApplication6”:已加载“C:\Documents and Settings\Administrator\My Documents\Visual Studio Projects\WindowsApplication6\bin\Debug\WindowsApplication6.exe”,符号已加载。
“WindowsApplication6.exe”:已加载“c:\winnt\assembly\gac\system.windows.forms\1.0.2411.0__b77a5c561934e089\system.windows.forms.dll”,未加载符号。
“WindowsApplication6.exe”:已加载“c:\winnt\assembly\gac\system\1.0.2411.0__b77a5c561934e089\system.dll”,未加载符号。
“WindowsApplication6.exe”:已加载“c:\winnt\assembly\gac\system.drawing\1.0.2411.0__b03f5f7f11d50a3a\system.drawing.dll”,未加载符号。
“WindowsApplication6.exe”:已加载“c:\winnt\assembly\gac\system.data\1.0.2411.0__b77a5c561934e089\system.data.dll”,未加载符号。
“WindowsApplication6.exe”:已加载“c:\winnt\assembly\gac\system.xml\1.0.2411.0__b77a5c561934e089\system.xml.dll”,未加载符号。
“WindowsApplication6.exe”:已加载“RegexAssembly1_0”,未加载符号。
“WindowsApplication6.exe”:已加载“RegexAssembly1_0.dll”,未加载符号。
未处理的“System.Data.OleDb.OleDbException”类型的异常出现在 system.data.dll 中
未处理的异常: System.Data.OleDb.OleDbException: 找不到可安装的 ISAM。
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
at WindowsApplication6.Form1..ctor() in c:\documents and settings\administrator\my documents\visual studio projects\windowsapplication6\form1.cs:line 44
at WindowsApplication6.Form1.Main() in c:\doc