When I was trying to read from an Access database Northwind, I got the following error message:

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 29: OleDbCommand objCommand = new OleDbCommand(strSQL, objConnection);
Line 30:
Line 31: objConnection.Open();
Line 32: dgSuppliers.DataSource = objCommand.ExecuteReader();
Line 33: dgSuppliers.DataBind();

My operating system is Windows XP professional and I'm using MSV.NET. Anyone can give me a clue?

Hi,

If youare using MS Access 2002, perhaps the following article can help:

http://support.microsoft.com/default...b;EN-US;283881

Cheers!


Marlon Villarama
Support Team
Web Burner Hosting
marlon@webburner.com
www.webburner.com
Toll-Free: 877-535-2876

You usually get this error when your connection string has a parameter value that does not exist, eg "Provider=Microsoft.Jet.OLEDB.4.0;Foo=Bar;"

Please post your connection string.

Cheers
Ken

www.adOpenStatic.com

this may be connection string problem try to change as below

conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & txtSource.Text & ";Jet OLEDB:Database Password=" & pwd.txt & ";"

Hello everybody,
i am reading Vb.net databases, and i came through chapter and i have written the code top open an access file database. i run the program and when i try to open the database this messages occurs "could not find intallable ISAM"
 some one help :)
this is my connection string
 objconnection = New OleDbConnection("provider= microsoft.jet.oledb.4.0;" & "datasource=" & txtDatabase.Text & " ; ")
thank Yiu

Hi,

Give your access database's name with the full path to the datasource parameter in your connection string

Eg:-

objconnection = New OleDbConnection("provider= microsoft.jet.oledb.4.0;" & "datasource=" C:\Data\Northwind.mdb " ; ")

nalla

The error is because of wrong connection string.
use string in format like this:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=FPAnalysisTool.mdb"

There should be a blank space between Data and Source.

hi prasadrn. Thanks for that solution. I was banging my head trying to solve from the suggestions at msdn kb. didn't notice that space. Your solution was very useful. I have posted it on my blog too.

Science is my God and Humanity, my religion

[u]KenSchaefer</u> is also correct, some times it gives error due to wrong parameters in connection string.


I Love XML and family

Hi

I am N.Ramasamy. I am working as a programmer. To connect oledb with MS Access, we want to write the query string as follows

string qs = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=e:\db\names.mdb";

 one important thing is we want to give space in between DAtA and Source

I have created one database named as names.mdb and it has name as a table.

The name table has the following fields

  1.ID
  2. Name

the database placed within e:\db

coding

string qs = @"PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source=e:\db\names.mdb";
        OleDbConnection con = new OleDbConnection(qs);
        con.Open();
        OleDbCommand com = new OleDbCommand( "select * from name", con);
        OleDbDataReader reader =com.ExecuteReader();
        while (reader.Read())
        {
            Response.Write("<br>" + reader["ID"]);

            Response.Write("<br>" + reader["Name"]);
        }