错误:找不到可安装的ISAM

本文关键字:ISAM 安装 找不到 错误 | 更新日期: 2023-09-27 18:26:03

每当我尝试执行使用数据库"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>

错误:找不到可安装的ISAM

找不到可安装的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"

用空格标注数据源。