Could not find installable ISAM.  
Author Message
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

I am trying to access some data in a Excel 2003 file and import it to a dataset using a oledb provider.Here is the code : string cnxString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=C:\\TEST.xls;" + "Extended Properties=Excel 8.0;"; this.excelConnection.ConnectionString = cnxString; this.excelConnection.Open();I keep getting this error :A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dllSystem.Data.OleDb.OleDbException: Could not find installable ISAM.I have search everywhere there is a space between data and source. I have read the KB articles but nothing seems to be doing it. Any help would be greatly appreciated.Thanks.

.NET Development1  
 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


This error will also be generated when the syntax of the connection string is incorrect. This commonly occurs when using multiple Extended Properties parameters. Below is an example:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=e:\My Documents\Book20.xls;Extended Properties=""Excel 8.0;HDR=NO;IMEX=1"""



 
 
ahmedilyas





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

you need to do this:

string theConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=book1.xls;Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\"";

does this help



 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

If the dll's are registered properly and the connection string is in proper format but both providers Micosoft.Jet.oledb Versions 4.0 and 3.51 are present on the Server could this cause the problem.

Thanks and Regards,

Little


 
 
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

Unfortunately no...Still getting :A first chance exception of type 'System.Data.OleDb.OleDbException' occurred in System.Data.dllSystem.Data.OleDb.OleDbException: Could not find installable ISAM. at System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at HyperDrive.Form1.btGetFile_Click(Object sender, EventArgs e) in C:\Documents and Settings\Prometheus\My Documents\Visual Studio 2005\Projects\HyperDrive - Modules externes\HyperDrive - Modules externes\Form1.cs:line 506Appreciate any further help you can offer...
 
 
MVP User





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


You can have multiple versions of the Jet OLEDB provider installed. Could you post the exact syntax of your connection string

 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

The connection string is of the format:

"Provider=Microsoft.Jet.OLEDB.4.0;Excel 8.0; Extended Properties=HDR=No; IMEX=1;Data Source=" & App.Path & "\..\Upload " & "ExcelFileName & ".xls"

where ExcelFileName is the name of the Excel file.

Thanks & Regards,

Little


 
 
VMazur





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

If code works fine on another PC, then it is quite possible that yu do not have Jet 4.0 installed on your PC. Jet is not a part of MDAC anymore and you need to download latest SP for JET and install it.

 
 
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

Hi. I copy pasted my code.

Still getting the same error. I tried installing sp8 for Jet4 but i get a message I already have a more current version. How can I check if jet4 is installed on my computer In the connection string the book1.xls stands for the file name, do I have to write the full file path


 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


I see some problems with the syntax. Try the following instead:

ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" App.Path & "\..\Upload" & ExcelFileName & ".xls" & ";Extended Properties=""Excel 8.0;HDR=NO;IMEX=1"""

I'm assuming your data source is correct, although I can't tell by looking at your connection string whether ExcelFileName is preceded by a back slash. In any event, the Extended Properties argument would not be evaluated properly in the example you posted.



 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

The ExcelFileName in the connection string contains the backslash and the excel filename.

The connection string posted by me does not cause any trouble in the development server but causes error "Cannot find installable ISAM" in the uat server where some service packs and hotfixes have been installed. Right now I don't know which ones. But I found that the version of the "Msjet40.dll" in development server is "4.0.8618.0" while that in uat server is "4.0.9025.0". Can this cause the problem

Thanks and Regards,

Little


 
 
ahmedilyas





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

no you dont need to write out the full path - I had that problem a while ago which I helped with someone else and the problem was the connection string and the connectionstring I posted resolved the problem.

update MDAC if you can (I know its not part of Jet)

just out of curiosity - what OS are you using XP



 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


OK, well I copied and pasted the connection string you posted and can't execute it because there is a syntax error, so you must be using something that's different.

Assuming that it runs fine on one system and not another I would say that you definitely have a configuration problem with respect to Jet and the Excel ISAM driver. What account did you log on to the server with when you re-registered the Excel ISAM driver



 
 
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

I just checked I have the 4.0.8618.0 version of the Msjet40.dll installed in Windows\System32...
 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

Logged in as the Server administrator and re-registered the "msexcl40.dll". Will reinstalling MDAC 2.8 help

Thanks and Regards,

Little


 
 
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

Just to make sure...

Here is the exact code :

string theConnectionString = "provider=Microsoft.Jet.OLEDB.4.0;data source=book1.xls;Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1;\"";

this.excelConnection.ConnectionString = theConnectionString;

this.excelConnection.Open();

How can I can I update MDAC

Thanks for your help.


 
 
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

Yes I am using XP...
 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


Which version of the Windows OS are you using

 
 
ahmedilyas





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

download MDAC 2.8 from Microsoft's website still however I doubt you need this but would be nice to illuminate any possibility

 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

We are using Windows 2000 Server SP4 Update RollUp1 , MDAC version 2.8 and the Microsoft Jet 4.0 Database Engine that comes with SP4 Update RollUp1.

We tried reinstalling MDAC and restarted the Server. But that doesn't solve the problem.

Thanks and Regards,

Little


 
 
Mgrondin345





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

I tried installing MDAC I get this...MDAC 2.8 RTM is incompatible with this version of Windows. All of its features are currently part of Windows.
 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


The Excel ISAM is actually intalled with Jet so I wouldn't expect an MDAC fix to resolve the issue.

Have you checked for multiple versions of Msexcl40.dll I believe the version that your installation should be using is 4.0.9025.0.



 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

The version of Msexcl40.dll is 4.0.9025.0. Will reinstalling the Jet component make a difference

Thanks & Regards,

Little


 
 
ahmedilyas





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

ok thats cool, you have the latest version of MDAC built in Windows.

hmm ill see what else I can dig up



 
 
ahmedilyas





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

ah...

try this, there is meant to be 2 quotes around the extended properties...

string theConnectionstring = ;



 
 
Paul P Clement IV





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top


If you can back out the update rollup you can try re-installing. Otherwise it may tell you that the latest version is already installed.

I seem to recall there was a way to resolve this issue through an Office install fix as well, but I'm assuming that you don't have Office installed on this machine.



 
 
Little





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top

Office is not installed on this machine. If Office was present on the machine and uninstalled could this cause the problem.

Is there any other way to read an Excel file besides using the Microsoft.Jet.OLEDB.4.0 provider

Thanks and Regards,

Little


 
 
MVP User





PostPosted: .NET Framework Data Access and Storage, Could not find installable ISAM. Top