错误：无法找到可安装的ISAM

Question

每当我尝试执行使用了“msaccess”数据库的项目时，都会出现以下错误：

Server Error in '/' Application.

Could not find installable ISAM.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM.

Source Error: 


Line 148:       // open DB Connection via OleDb
Line 149:       Connection = new OleDbConnection(sConnectionString);
Line 150:       Connection.Open();
Line 151:       
Line 152:   }

Source File: D:\excelsior\.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking System\BugTrackingNew\BugTrackingNew\CCUtility.cs    Line: 150 

Stack Trace: 


[OleDbException (0x80004005): Could not find installable ISAM.]
   System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +968297
   System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +86
   System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
   System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4861516
   System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
   System.Data.OleDb.OleDbConnection.Open() +40
   Bug_Management.CCUtility.DBOpen() in D:\excelsior\.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking System\BugTrackingNew\BugTrackingNew\CCUtility.cs:150
   Bug_Management.CCUtility..ctor(Object parent) in D:\excelsior\.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking System\BugTrackingNew\BugTrackingNew\CCUtility.cs:80
   Bug_Management.ProjectMaint1.Page_Load(Object sender, EventArgs e) in D:\excelsior\.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking System\BugTrackingNew\BugTrackingNew\ProjectMaint.cs:76
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +50
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627

Version Information: Microsoft .NET Framework Version:2.0.50727.3053; ASP.NET Version:2.0.50727.3053

编辑

<appSettings> <add key="sDBConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;datasource=C:\excelsior\.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking SystemAccessDB.mdb"/> </appSettings>

- havan

---

请发布您的连接字符串。 - Fionnuala

抱歉，我忘记了。这是我的连接字符串：<appSettings> <add key="sDBConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;datasource=C:\excelsior.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking SystemAccessDB.mdb"/> </appSettings> - havan

<appSettings> <add key="sDBConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;datasource=C:\excelsior.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking SystemAccessDB.mdb"/>
</appSettings> - havan

应该是“数据源”，而不是“datasource”（http://www.connectionstrings.com/access）。 - Fionnuala

“Could not find installable ISAM” 是典型的连接字符串错误，因此我认为首先应该更正该字符串。 - Fionnuala

Answer 1

找不到可安装的 ISAM 通常是由于连接字符串有误导致的。

"Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\excelsior\.Net Applications\TDAPP8-Web_Based_Bug_tracking_system\Web based Bug Tracking SystemAccessDB.mdb"

请在数据源中使用空格。

- Fionnuala

---

谢谢，我也漏了一个空格，其他答案没有帮到我！ - krillgar

请注意，在指定密码时，“Jet OLEDB”和“Database Password”之间使用冒号（:），而不是分号（;）--> “Jet OLEDB：Database Password”。 - SNAFUBAR