超级难题:为什么c#中通过OLEDB连接ACCESS数据库会出现这样的错误?
超级难题:为什么c#中通过OLEDB连接ACCESS数据库会出现这样的错误?
代码:
using System;
using System.Data;
using System.Data.OleDb;
namespace Wrox.BeginningCSharpDatabase.Chapter05
{
class ConnectionExample3
{
static void Main()
{
OleDbConnection thisConnection =new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;"+
@"DataSource="+
@"d:\m.mdb");
try
{
thisConnection.Open();
Console.WriteLine("OLE DB Connection Successfully Opened!");
Console.WriteLine("Connection Properties:");
Console.WriteLine("\tConnection String:{0}",thisConnection.ConnectionString);
Console.WriteLine("\tDatabase:{0}",thisConnection.Database);
Console.WriteLine("\tDataSource:{0}",thisConnection.DataSource);
Console.WriteLine("\tServerVersion:{0}",thisConnection.ServerVersion);
Console.WriteLine("\tState:{0}",thisConnection.State);
Console.WriteLine("\tProvider:{0}",thisConnection.Provider);
}
catch(OleDbException ex)
{
Console.WriteLine(ex.ToString());
}
finally
{
thisConnection.Close();
Console.WriteLine("Connection Closed.");
}
}
}
}
错误信息:
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 Wrox.BeginningCSharpDatabase.Chapter05.ConnectionExample3.Main() in e:\c#
begcsharpdb\p98-4\class1.cs:line 18
Connection Closed.
问题点数:30、回复次数:5Top
1 楼wwwwpig(菜鸟)回复于 2005-03-04 19:53:36 得分 0
补充一下,错误出现在thisConnection.Open();时Top
2 楼fangxinggood(JustACoder)回复于 2005-03-04 19:58:52 得分 0
d:\m.mdb 看看数据库存在不?Top
3 楼AllenTing(今天你GC了吗???)回复于 2005-03-04 20:13:19 得分 10
看看这个:
http://www.ask321.com/ask15/ask192796.htmTop
4 楼xiaohuasz()回复于 2005-03-04 20:17:42 得分 10
DataSource->Data Source 中间空格Top
5 楼yufenfeila(雨纷飞啦)回复于 2005-03-04 20:20:47 得分 10
OleDbConnection thisConnection =new OleDbConnection(
@"Provider=Microsoft.Jet.OLEDB.4.0;"+
@"DataSource="+
@"d:\m.mdb");
中的 @"DataSource="+ 改成 @"Data Source="+
有个空格Top




