.NETGURU
Could not find installable ISAM.
Messages   Related Types
This message was discovered on ASPFriends.com 'ngfx-oledb' list.
Responses highlighted in red are from those people who are likely to be able to contribute good, authoratitive information to this discussion. They include Microsoft employees, MVP's and others who IMHO contribute well to these kinds of discussions.

Srinivasan P
Hi all,

A newbie to ASP.Net. I am trying to retrieve database rows with a dataset and I am getting the error above.

Thanks inAdvance

Regards
Srini

Source Error:

Line 17:
Line 18:     dim ds as Dataset = new Dataset()
Line 19:     myCommand.Fill(ds, "tblUsers")
Line 20: end sub
Line 21: </script>

The code is given below
<%@ Page Language="VB" debug="true"%>
<%@ Import NameSpace = "System.Data" %>
<%@ Import Namespace = "System.Data.OleDB" %>

<script runat="server">

sub Page_Load(obj as Object, E as EventArgs)
' Set Up connection

dim myConnection as new OleDBConnection("Provider=Microsoft.Jet.OLEDB.4.0;""Data

Source=F:\Sites\ASP.Net\data\banking.mdb")

' Open Connection

dim myCommand as new OleDbDataAdapter("select * from tblUsers", myConnection)

' Fill Dataset

dim ds as Dataset = new Dataset()
myCommand.Fill(ds, "tblUsers")
end sub
</script>

<html><body>
</body></html>
Reply to this message...
 
    
Das (VIP)
ACC2000: "Could Not Find Installable ISAM" Error Message

Q209805

The extract of the above document is:

Microsoft Access 2000
----------------------------------------------------------------------------
----
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and a Microsoft
Access project (.adp).

For a Microsoft Access 2002 version of this article, see Q283881.
For a Microsoft Access 97 version of this article, see Q90111.

SYMPTOMS
If you try to import, export, or link a file by using an indexed sequential
access method (ISAM) driver, you may receive an error message if Microsoft
Access cannot find the ISAM driver.

CAUSE
ISAM drivers are used by Access to update file formats other than its own.
If the path to the ISAM driver in your Windows Registry is invalid, or if
the ISAM driver does not exist, you may receive the following error
messages:

Could not find installable ISAM
-or-
The wizard is unable to access information in the file '<pathname>'. Please
check that the file exists and is the correct format.

RESOLUTION
To correct the problem, you need to correct path name errors in the Windows
Registry, and install or replace the problem file.

In the case of the first error message, the file name is directly related to
the attempted operation.

In the case of the second error message, the file name is mentioned in the
text of the message.

Locate the relevant file in the following table.

File Name Import/Export ISAM for: Windows Registry
Msexcl40.dll Microsoft Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel
Msexch40.dll Microsoft Exchange
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Exchange
Msrd2x40.dll Microsoft Jet 2.x
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 2.x
Msrd3x40.dll Microsoft Jet 3.x
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 3.x
Msltus40.dll Lotus 1-2-3
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Lotus
Mspbde40.dll Imprise Paradox
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Paradox
Mstext40.dll Text HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text
Msxbde40.dll dBase
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Xbase

Use Windows Explorer to search for the file.

If the file is found, record its path name; if it is not found, proceed to
step 9.

Open the Windows Registry Editor.

WARNING: Using Registry Editor incorrectly can cause serious problems that
may require you to reinstall your operating system. Microsoft cannot
guarantee that problems resulting from the incorrect use of Registry Editor
can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and
Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete
Information in the Registry" and "Edit Registry Data" Help topics in
Regedt32.exe. Note that you should back up the registry before you edit it.
If you are running Windows NT or Windows 2000, you should also update your
Emergency Repair Disk (ERD).

Browse to the registry subkey described in the table, and check the path
name against the actual path name.

Correct the path name if it is incorrect; proceed with these steps if it is
correct.

Close the Registry Editor. If you changed the path name, repeat the process
that produced the original error.

If the error persists, or if the path name was correct in step 6, rename the
file.

Start the Add/Remove Programs tool, start the Office 2000 Setup program, and
select the Repair Office option.

Additional query words: prb 1 2 3 123 can't can t cannot not could couldn
find installable ISAM

Keywords : kberrmsg kbdta
Issue type : kbprb
Technology : kbAccessSearch kbAccess2000 kbAccess2000Search

:-),
Das.

----- Original Message -----
From: "Srinivasan P" <Click here to reveal e-mail address>
To: "ngfx-oledb" <Click here to reveal e-mail address>
Sent: Friday, March 01, 2002 12:43 PM
Subject: [ngfx-oledb] Could not find installable ISAM.

> -- Moved from [aspngdata] to [ngfx-oledb] by Charles M. Carroll
<Click here to reveal e-mail address> --
[Original message clipped]

_________________________________________________________

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.com

Reply to this message...
 
    
neha seth
(Type your message here)

--------------------------------
From: neha seth
the same error iam getting while executing the program,what should i do.
Source Error:

Line 17:
Line 18: dim ds as Dataset = new Dataset()
Line 19: myCommand.Fill(ds, "tblUsers")
Line 20: end sub
Line 21: </script>

The code is given below
<%@ Page Language="VB" debug="true"%>
<%@ Import NameSpace = "System.Data" %>
<%@ Import Namespace = "System.Data.OleDB" %>

<script runat="server">

sub Page_Load(obj as Object, E as EventArgs)
' Set Up connection

dim myConnection as new OleDBConnection("Provider=Microsoft.Jet.OLEDB.4.0;""Data

Source=F:\Sites\ASP.Net\data\banking.mdb")

' Open Connection

dim myCommand as new OleDbDataAdapter("select * from tblUsers", myConnection)

' Fill Dataset

dim ds as Dataset = new Dataset()
myCommand.Fill(ds, "tblUsers")
end sub
</script>

<html><body>
</body></html>
Reply to this message...
 
 
System.Data.OleDb.OleDbDataAdapter
System.EventArgs




ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
Ad


Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews
.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT
Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project
FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.
Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials
 
ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification
 Copyright © ExamGuru, Inc. 2001-2006
Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification