讀取Excel中的數(shù)據(jù)存到數(shù)據(jù)庫(kù)，但在讀的時(shí)候報(bào)錯(cuò) 找不到可安裝的 ISAM,這個(gè)錯(cuò)在本地調(diào)試時(shí)沒有出現(xiàn)，但上傳到服務(wù)器的時(shí)候就出現(xiàn)了，我的機(jī)器是XP的系統(tǒng)，服務(wù)器是2003的服務(wù)器。在網(wǎng)上找了很多解決方法，包括修改連接字符串和注冊(cè)Excel組件，但都無(wú)效?，F(xiàn)在將錯(cuò)誤貼出來(lái)，希望有高手來(lái)幫忙解決，謝謝 “/fwadmin”應(yīng)用程序中的服務(wù)器錯(cuò)誤。-------------------------------------------------------------------------------- 找不到可安裝的 ISAM。 說(shuō)明: 執(zhí)行當(dāng)前 Web 請(qǐng)求期間，出現(xiàn)未處理的異常。請(qǐng)檢查堆棧跟蹤信息，以了解有關(guān)該錯(cuò)誤以及代碼中導(dǎo)致錯(cuò)誤的出處的詳細(xì)信息。 異常詳細(xì)信息: System.Data.OleDb.OleDbException: 找不到可安裝的 ISAM。 源錯(cuò)誤: 行 84:???????????????? DataSet ds = new DataSet();行 85:????? 行 86:???????????????????? sda.Fill(ds);行 87:???????????????????? flag = true;行 88: ? 源文件: d:\Webroot\lms_deqing\fwadmin\Manager\Module\FrameWork\SystemApp\ExamManager\paper_manage\excel_up.aspx.cs??? 行: 86 堆棧跟蹤: [OleDbException (0x80004005): 找不到可安裝的 ISAM。]?? System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +969373?? 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) +4863644?? System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117?? System.Data.OleDb.OleDbConnection.Open() +40?? System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +31?? System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +112?? System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287?? System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94?? excel_up.GetExcelData(String filePath, String& info) in d:\Webroot\lms_deqing\fwadmin\Manager\Module\FrameWork\SystemApp\ExamManager\paper_manage\excel_up.aspx.cs:86?? excel_up.AddExcelPaperData(String filePath, String PAPER_ID, String CONTENT_TYPE, String AUTHOR_NAME, String& info) in d:\Webroot\lms_deqing\fwadmin\Manager\Module\FrameWork\SystemApp\ExamManager\paper_manage\excel_up.aspx.cs:109?? excel_up.btnUp_Click(Object sender, EventArgs e) in d:\Webroot\lms_deqing\fwadmin\Manager\Module\FrameWork\SystemApp\ExamManager\paper_manage\excel_up.aspx.cs:52?? System.Web.UI.WebControls.Button.OnClick(EventArgs e) +111?? System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +110?? System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10?? System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13?? System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36?? System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565 也許還有人懷疑我的連接字符串，現(xiàn)在也貼出來(lái)，大家看下 ?string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+filePath+";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";