Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old August 25th, 2003, 04:01 PM
Registered User
 
Join Date: Aug 2003
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Could not find installable ISAM

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?

 
Old August 25th, 2003, 09:09 PM
Authorized User
 
Join Date: Jun 2003
Location: Quezon City, MM, Philippines.
Posts: 97
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to planeswalk
Default

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
 
Old August 26th, 2003, 03:36 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Sydney, NSW, Australia.
Posts: 111
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old September 5th, 2003, 07:07 AM
Authorized User
 
Join Date: Aug 2003
Location: , , .
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 & ";"

 
Old December 26th, 2005, 09:48 AM
Registered User
 
Join Date: Dec 2005
Location: Beirut, , Lebanon.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old December 26th, 2005, 11:12 PM
Friend of Wrox
Points: 464, Level: 7
Points: 464, Level: 7 Points: 464, Level: 7 Points: 464, Level: 7
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Dec 2005
Location: Colombo, , Sri Lanka.
Posts: 132
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to nalla Send a message via Yahoo to nalla
Default



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



 
Old April 14th, 2006, 07:01 AM
Registered User
 
Join Date: Apr 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

 
Old February 18th, 2007, 02:36 PM
Registered User
 
Join Date: Feb 2007
Location: Hauz Khas New Delhi, Delhi, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
 
Old April 19th, 2007, 02:51 AM
Authorized User
 
Join Date: Mar 2007
Location: Dubai, dubai, United Arab Emirates.
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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


I Love XML and family
 
Old May 2nd, 2007, 12:35 AM
Registered User
 
Join Date: May 2007
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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"]);
        }






Similar Threads
Thread Thread Starter Forum Replies Last Post
Error: Could not find installable ISAM dummy Classic ASP Basics 0 May 16th, 2007 02:36 AM
"Could not find installable ISAM" evidica ASP.NET 1.0 and 1.1 Basics 3 March 12th, 2007 11:27 AM
Could not find installable isam Johno13 BOOK: Beginning VB.NET Databases 1 October 5th, 2006 11:46 AM
Couldnot find installable ISAM jitheshsunny ASP.NET 1.x and 2.0 Application Design 1 February 1st, 2006 03:08 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.