PC Review


Reply
Thread Tools Rate Thread

Could not find installable ISAM

 
 
sina
Guest
Posts: n/a
 
      28th Aug 2007
hi, engineer:

Today, I used the following program to open excel 2003 file, I got an issue.

the connect string :
if (System.IO.File.Exists(path))
{
strConn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0;IMEX=1";
OleDbConnection Conn = new OleDbConnection(strConn);
string SQL = "select * from [AssayResExample01$]";

OleDbDataAdapter da = new OleDbDataAdapter(SQL, strConn);
DataSet ds = new DataSet();
da.Fill(ds);
Conn.Close();

this.dgImport.DataSource = ds;
this.dgImport.DataBind();
}


Issue:
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 93: OleDbDataAdapter da = new OleDbDataAdapter(SQL, strConn);
Line 94: DataSet ds = new DataSet();
Line 95: da.Fill(ds);
Line 96: Conn.Close();
Line 97: Stack Trace: [OleDbException (0x80004005): Could not find installable ISAM.]
System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) +1059617
System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +53
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105
System.Data.OleDb.OleDbConnection.Open() +37
System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +121
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +137
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +86
TRX.Import.ListData() in E:\TRX\TRX\Import.aspx.cs:95
TRX.Import.btnConnecttoBASIS_Click(Object sender, EventArgs e) in E:\TRX\TRX\Import.aspx.cs:32
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102



could you tell me how to slove it?
thanks.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
can not find installable ISAM LN Microsoft Access Reports 0 15th Oct 2008 11:08 PM
Cannot find installable ISAM luvgreen Microsoft Access External Data 0 6th Mar 2008 03:28 PM
Could not find installable ISAM =?Utf-8?B?QmlsbCBQaGlsbGlwcw==?= Microsoft Access VBA Modules 0 7th Sep 2005 01:06 AM
Could not find installable ISAM? A. Barabus Microsoft Access 1 9th May 2004 03:50 AM
Could not find installable ISAM. Brent Microsoft Dot NET Framework 5 3rd May 2004 04:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:56 AM.