p2p.wrox.com: Archives - aspx

aspx_beginners thread: Could not find installable ISAM

Message #1 by "Z Kofler" <zkofler@h...> on Mon, 22 Apr 2002 19:26:09 -0700

<html><div style='background-color:'><DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV>
<DIV></DIV></DIV>
<DIV></DIV><%@Import Namespace="System.Data"%>
<DIV></DIV>
<DIV>YIKES!&nbsp; I am going through the example in "Beginning ASP.NET using C#" on page 72 and I get the following error
(btw, I've downloaded and reinstalled both MDAC 2.7 and Jet stuff and rebooted; I've got Windows 2000 Server installed on my home
system):</DIV>
<DIV></DIV>
<P><STRONG>Server Error in '/'
Application</STRONG>.<BR><STRONG>--------------------------------------------------------------------------------&
lt;/STRONG></P>
<DIV></DIV>
<P><STRONG>Could not find installable ISAM. <BR></STRONG>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.&nbsp;</P>
<DIV></DIV>
<P>Exception Details: System.Data.OleDb.OleDbException: Could not find installable ISAM.</P>
<DIV></DIV>
<P>Source Error:&nbsp;<BR>Line 20: &nbsp;objConnection = new OleDbConnection(strConnect);<BR>Line 21:
&nbsp;objCommand = new OleDbDataAdapter(strCommand, objConnection);<BR>Line 22: &nbsp;objCommand.Fill(DataSet1,
"Products");<BR>Line 23: &nbsp;DataGrid1.DataSource=DataSet1.Tables["Products"].DefaultView;<BR>Line 24:
&nbsp;DataGrid1.DataBind();<BR>&nbsp;</P>
<DIV></DIV>
<P>Source File: c:\inetpub\wwwroot\datacontrol.aspx&nbsp;&nbsp;&nbsp; Line: 22 </P>
<DIV></DIV>
<P>Stack Trace: </P>
<DIV></DIV>
<P><BR>[OleDbException (0x80004005): Could not find installable ISAM.]<BR>&nbsp;&nbsp;
System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) +20<BR>&nbsp;&nbsp;
System.Data.OleDb.OleDbConnection.InitializeProvider() +57<BR>&nbsp;&nbsp; System.Data.OleDb.OleDbConnection.Open()
+131<BR>&nbsp;&nbsp; System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState&amp;
originalState) +44<BR>&nbsp;&nbsp; System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32
maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +98<BR>&nbsp;&nbsp;
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +77<BR>&nbsp;&nbsp; System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+36<BR>&nbsp;&nbsp; ASP.DataControl_aspx.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\datacontrol.aspx:22<BR>&nbsp;&nbsp; System.Web.UI.Control.OnLoad(EventArgs e)
+67<BR>&nbsp;&nbsp; System.Web.UI.Control.LoadRecursive() +29<BR>&nbsp;&nbsp;
System.Web.UI.Page.ProcessRequestMain() +724</P>
<DIV></DIV>
<P>&nbsp;</P>
<DIV></DIV>
<P><BR>--------------------------------------------------------------------------------<BR>Version Information:
Microsoft .NET Framework Version:1.0.3705.209; ASP.NET Version:1.0.3705.0 &nbsp;</P>
<DIV></DIV>
<P>&nbsp;</P>
<DIV></DIV>
<P><STRONG>Source Code:<%@Import Namespace="System.Data.OleDb"%><%@Page Language="C#" Debug="true"%> 
<DIV></DIV>
<SCRIPT language=c# runat="server">
</DIV>void Page_Load(object sender, EventArgs e)
</DIV>{
</DIV>	OleDbConnection objConnection;
</DIV>	OleDbDataAdapter objCommand;
</DIV>	string strConnect;
</DIV>	string strCommand;
</DIV>	DataSet DataSet1= new DataSet();
</DIV>	strConnect =@"Provider=Microsoft.Jet.OLEDB.4.0;";
</DIV>	// If you don't have the grocertogo.mdb db, then you will have to
</DIV>	// change the following three lines to point to a different database
</DIV>	strConnect+=@"Data Source=C:\Program Files\Microsoft Visual Studio
.NET\FrameworkSDK\Samples\QuickStart\aspplus\samples\grocertogo\data\grocertogo.mdb;";
</DIV>	strConnect+=" Persist Sercurity Info=False";
</DIV>	// If you don't have grocertogo.mdb, you will have to change this line too
</DIV>	strCommand="SELECT ProductName, UnitPrice FROM Products";
</DIV>	objConnection = new OleDbConnection(strConnect);
</DIV>	objCommand = new OleDbDataAdapter(strCommand, objConnection);
</DIV>	objCommand.Fill(DataSet1, "Products");
</DIV>	DataGrid1.DataSource=DataSet1.Tables["Products"].DefaultView;
</DIV>	DataGrid1.DataBind();
</DIV>}
</DIV></SCRIPT>

<DIV></DIV><?xml:namespace prefix = asp /><asp:DataGrid id=DataGrid1
runat="server"></asp:DataGrid><BR></STRONG>&lt;<A href="mailto:%@Import">%@Import</A>
Namespace="System.Data"%&gt;<BR>&lt;<A href="mailto:%@Import">%@Import</A>
Namespace="System.Data.OleDb"%&gt;<BR>&lt;<A href="mailto:%@Page">%@Page</A> Language="C#"
Debug="true"%&gt;
<P></P>
<DIV></DIV>
<P>&lt;script language="c#" runat="server"&gt;<BR>void Page_Load(object sender, EventArgs
e)<BR>{<BR>&nbsp;OleDbConnection objConnection;<BR>&nbsp;OleDbDataAdapter
objCommand;<BR>&nbsp;string strConnect;<BR>&nbsp;string strCommand;<BR>&nbsp;DataSet DataSet1= new
DataSet();<BR>&nbsp;strConnect <A
href='mailto:=@"Provider=Microsoft.Jet.OLEDB.4.0'>=@"Provider=Microsoft.Jet.OLEDB.4.0</A>;";<BR>&nbsp;// If you
don't have the grocertogo.mdb db, then you will have to<BR>&nbsp;// change the following three lines to point to a
different database<BR>&nbsp;<A href='mailto:strConnect+=@"Data'>strConnect+=@"Data</A> Source=C:\Program
Files\Microsoft Visual Studio
.NET\FrameworkSDK\Samples\QuickStart\aspplus\samples\grocertogo\data\grocertogo.mdb;";<BR>&nbsp;strConnect+=" Persist
Sercurity Info=False";<BR>&nbsp;// If you don't have grocertogo.mdb, you will have to change this line
too<BR>&nbsp;strCommand="SELECT ProductName, UnitPrice FROM Products";<BR>&nbsp;objConnection = new
OleDbConnection(strConnect);<BR>&nbsp;objCommand = new OleDbDataAdapter(strCommand,
objConnection);<BR>&nbsp;objCommand.Fill(DataSet1,
"Products");<BR>&nbsp;DataGrid1.DataSource=DataSet1.Tables["Products"].DefaultView;<BR>&nbsp;DataGrid1.DataBind(
);<BR>}<BR>&lt;/script&gt;<BR>&lt;html&gt;<BR>&lt;head&gt;&lt;title&gt;Data
Grid Control
example&lt;/title&gt;&lt;/head&gt;<BR>&lt;body&gt;<BR>&nbsp;&lt;asp:DataGrid
id="DataGrid1" runat="server" /&gt;<BR>&lt;/body&gt;<BR>&lt;/html&gt;<BR><BR></P>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV><EM>John Kofler</EM></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV></div><br clear=all><hr>MSN Photos is the easiest way to share and print your photos: <a
href='http://g.msn.com/1HM205401/k'>Click Here</a><br></html>

Message #2 by "Jon Maz" <jonmaz@s...> on Tue, 23 Apr 2002 08:44:23

Have a look at this thread for a discussion of the same problem:

http://www.aspmessageboard.com/forum/aspplus.asp?M=375070&F=36&P=1

Turns out to have been a .NET beta bug...

hth,

JON

Return to Index

P2P Archives