|
 |
aspx_beginners thread: Could not find installable ISAM - Chapter 2
Message #1 by "Kyle Peters" <jkyle@k...> on Fri, 8 Nov 2002 03:57:07
|
|
I am loosing hair on this - I am an asp.net newbie. I am following
the "Try-it-out - binding to a database" from the book, "ASP.NET 1.0 with
Visual Basic". I am running IIS on a WIN2000 Pro, trying in vain to
connect the sample Access database that downloaded from wrox (in Office
2000 Pro). This was supposed to be a simple example. However, and I was
warned, if I can't get this to work, the rest of the book is theory. For
want it is worth, all examples ran ok up to this point.
I am receiveing the error (like many others, but nothing they suggest
helps):
"Could not find installable ISAM"
The path to the database is true and correct (unless copy and paste lies)
Here's the code...
<%@Page Language="vb" Debug="true" %>
<%@Import Namespace="System.Data" %>
<%@Import Namespace="System.Data.OleDb" %>
<script language="VB" runat="server">
Sub Page_Load(Sender As Object, E As EventArgs)
Dim objConnection As OleDbConnection
Dim objCommand As OleDbDataAdapter
Dim strConnect As String
Dim strCommand As String
Dim DataSet1 as New DataSet
strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
strConnect += "C:\Program Files\Microsoft Visual
Studio.NET\FrameworkSDK\"
strConnect += "Samples\QuickStart\aspplus\samples\grocertogo\data\"
strConnect += "grocertogo.mdb;"
strConnect += "Persist Security Info=False"
strCommand = "SELECT ProductName, UnitPrice FROM Products"
objConnection = New OleDbConnection(strConnect)
objCommand = New OleDbDataAdapter(strCommand, objConnection)
'dies a horrible death on next line
objCommand.Fill(DataSet1, "Products")
DataGrid1.DataSource=DataSet1.Tables("Products").DefaultView
DataGrid1.DataBind()
End Sub
</script>
<html>
<head>
<title>DataGrid Control Example</title>
</head>
<body>
<asp:DataGrid id="DataGrid1" runat="server" />
</body>
</html>
Any and All help is appreciated,
Kyle
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 8 Nov 2002 15:19:55 +1100
|
|
Your connection string is invalid.
Check this out, under scenario 2:
http://www.adopenstatic.com/faq/80040e21.asp
<quote>
This is not to be confused...
</quote>
You are missing the bit that says:
Data Source=...
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Kyle Peters" <jkyle@k...>
To: "aspx_beginners" <aspx_beginners@p...>
Sent: Friday, November 08, 2002 3:57 AM
Subject: [aspx_beginners] Could not find installable ISAM - Chapter 2
: I am loosing hair on this - I am an asp.net newbie. I am following
: the "Try-it-out - binding to a database" from the book, "ASP.NET 1.0 with
: Visual Basic". I am running IIS on a WIN2000 Pro, trying in vain to
: connect the sample Access database that downloaded from wrox (in Office
: 2000 Pro). This was supposed to be a simple example. However, and I was
: warned, if I can't get this to work, the rest of the book is theory. For
: want it is worth, all examples ran ok up to this point.
:
: I am receiveing the error (like many others, but nothing they suggest
: helps):
: "Could not find installable ISAM"
:
: The path to the database is true and correct (unless copy and paste lies)
:
: Here's the code...
: <%@Page Language="vb" Debug="true" %>
: <%@Import Namespace="System.Data" %>
: <%@Import Namespace="System.Data.OleDb" %>
: <script language="VB" runat="server">
: Sub Page_Load(Sender As Object, E As EventArgs)
: Dim objConnection As OleDbConnection
: Dim objCommand As OleDbDataAdapter
: Dim strConnect As String
: Dim strCommand As String
: Dim DataSet1 as New DataSet
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
: strConnect += "C:\Program Files\Microsoft Visual
: Studio.NET\FrameworkSDK\"
: strConnect += "Samples\QuickStart\aspplus\samples\grocertogo\data\"
: strConnect += "grocertogo.mdb;"
: strConnect += "Persist Security Info=False"
:
: strCommand = "SELECT ProductName, UnitPrice FROM Products"
: objConnection = New OleDbConnection(strConnect)
: objCommand = New OleDbDataAdapter(strCommand, objConnection)
: 'dies a horrible death on next line
: objCommand.Fill(DataSet1, "Products")
: DataGrid1.DataSource=DataSet1.Tables("Products").DefaultView
: DataGrid1.DataBind()
: End Sub
: </script>
:
: <html>
: <head>
: <title>DataGrid Control Example</title>
: </head>
: <body>
: <asp:DataGrid id="DataGrid1" runat="server" />
: </body>
: </html>
:
: Any and All help is appreciated,
:
: Kyle
:
Message #3 by "Kyle Peters" <jkyle@k...> on Fri, 8 Nov 2002 15:44:43
|
|
Ken,
Thanks for the feedback. Unfortunately, that did not solve the problem.
Any other suggestions? Where are the authors for tech support on
these "book" issues? I am confident, based on what I have read, that the
problem is somewhere in the connection string, but I don't know what it
could be. I have installed the Microsoft Jet 4.0 SP3 (Jet40Sp3_Comp.exe)
and the latest MDAC 2.7, so unless there is something else I am
missing...I am just stuck. I have even peeked into the registry, but I am
not sure what I am looking for, and sure as heck don't want to tinker
under THAT hood.
Regards,
Kyle
> Your connection string is invalid.
Check this out, under scenario 2:
http://www.adopenstatic.com/faq/80040e21.asp
<quote>
This is not to be confused...
</quote>
You are missing the bit that says:
Data Source=...
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Kyle Peters" <jkyle@k...>
To: "aspx_beginners" <aspx_beginners@p...>
Sent: Friday, November 08, 2002 3:57 AM
Subject: [aspx_beginners] Could not find installable ISAM - Chapter 2
: I am loosing hair on this - I am an asp.net newbie. I am following
: the "Try-it-out - binding to a database" from the book, "ASP.NET 1.0 with
: Visual Basic". I am running IIS on a WIN2000 Pro, trying in vain to
: connect the sample Access database that downloaded from wrox (in Office
: 2000 Pro). This was supposed to be a simple example. However, and I was
: warned, if I can't get this to work, the rest of the book is theory. For
: want it is worth, all examples ran ok up to this point.
:
: I am receiveing the error (like many others, but nothing they suggest
: helps):
: "Could not find installable ISAM"
:
: The path to the database is true and correct (unless copy and paste lies)
:
: Here's the code...
: <%@Page Language="vb" Debug="true" %>
: <%@Import Namespace="System.Data" %>
: <%@Import Namespace="System.Data.OleDb" %>
: <script language="VB" runat="server">
: Sub Page_Load(Sender As Object, E As EventArgs)
: Dim objConnection As OleDbConnection
: Dim objCommand As OleDbDataAdapter
: Dim strConnect As String
: Dim strCommand As String
: Dim DataSet1 as New DataSet
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
: strConnect += "C:\Program Files\Microsoft Visual
: Studio.NET\FrameworkSDK\"
: strConnect += "Samples\QuickStart\aspplus\samples\grocertogo\data\"
: strConnect += "grocertogo.mdb;"
: strConnect += "Persist Security Info=False"
:
: strCommand = "SELECT ProductName, UnitPrice FROM Products"
: objConnection = New OleDbConnection(strConnect)
: objCommand = New OleDbDataAdapter(strCommand, objConnection)
: 'dies a horrible death on next line
: objCommand.Fill(DataSet1, "Products")
: DataGrid1.DataSource=DataSet1.Tables("Products").DefaultView
: DataGrid1.DataBind()
: End Sub
: </script>
:
: <html>
: <head>
: <title>DataGrid Control Example</title>
: </head>
: <body>
: <asp:DataGrid id="DataGrid1" runat="server" />
: </body>
: </html>
:
: Any and All help is appreciated,
:
: Kyle
:
Message #4 by "Paul Riley" <rilez@t...> on Fri, 8 Nov 2002 15:40:55 -0000
|
|
Before trying the connection response.write the connection string to
just double check the file exists in the exact location. Once you do can
you reply here and paste the connection string?
-----Original Message-----
From: Kyle Peters [mailto:jkyle@k...]
Sent: 08 November 2002 15:45
To: aspx_beginners
Subject: [aspx_beginners] Re: Could not find installable ISAM - Chapter
2
Ken,
Thanks for the feedback. Unfortunately, that did not solve the problem.
Any other suggestions? Where are the authors for tech support on
these "book" issues? I am confident, based on what I have read, that the
problem is somewhere in the connection string, but I don't know what it
could be. I have installed the Microsoft Jet 4.0 SP3
(Jet40Sp3_Comp.exe)
and the latest MDAC 2.7, so unless there is something else I am
missing...I am just stuck. I have even peeked into the registry, but I
am
not sure what I am looking for, and sure as heck don't want to tinker
under THAT hood.
Regards,
Kyle
> Your connection string is invalid.
Check this out, under scenario 2:
http://www.adopenstatic.com/faq/80040e21.asp
<quote>
This is not to be confused...
</quote>
You are missing the bit that says:
Data Source=...
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
----- Original Message -----
From: "Kyle Peters" <jkyle@k...>
To: "aspx_beginners" <aspx_beginners@p...>
Sent: Friday, November 08, 2002 3:57 AM
Subject: [aspx_beginners] Could not find installable ISAM - Chapter 2
: I am loosing hair on this - I am an asp.net newbie. I am following
: the "Try-it-out - binding to a database" from the book, "ASP.NET 1.0
with
: Visual Basic". I am running IIS on a WIN2000 Pro, trying in vain to
: connect the sample Access database that downloaded from wrox (in
Office
: 2000 Pro). This was supposed to be a simple example. However, and I
was
: warned, if I can't get this to work, the rest of the book is theory.
For
: want it is worth, all examples ran ok up to this point.
:
: I am receiveing the error (like many others, but nothing they suggest
: helps):
: "Could not find installable ISAM"
:
: The path to the database is true and correct (unless copy and paste
lies)
:
: Here's the code...
: <%@Page Language="vb" Debug="true" %>
: <%@Import Namespace="System.Data" %>
: <%@Import Namespace="System.Data.OleDb" %>
: <script language="VB" runat="server">
: Sub Page_Load(Sender As Object, E As EventArgs)
: Dim objConnection As OleDbConnection
: Dim objCommand As OleDbDataAdapter
: Dim strConnect As String
: Dim strCommand As String
: Dim DataSet1 as New DataSet
:
: strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"
: strConnect += "C:\Program Files\Microsoft Visual
: Studio.NET\FrameworkSDK\"
: strConnect += "Samples\QuickStart\aspplus\samples\grocertogo\data\"
: strConnect += "grocertogo.mdb;"
: strConnect += "Persist Security Info=False"
:
: strCommand = "SELECT ProductName, UnitPrice FROM Products"
: objConnection = New OleDbConnection(strConnect)
: objCommand = New OleDbDataAdapter(strCommand, objConnection)
: 'dies a horrible death on next line
: objCommand.Fill(DataSet1, "Products")
: DataGrid1.DataSource=DataSet1.Tables("Products").DefaultView
: DataGrid1.DataBind()
: End Sub
: </script>
:
: <html>
: <head>
: <title>DataGrid Control Example</title>
: </head>
: <body>
: <asp:DataGrid id="DataGrid1" runat="server" />
: </body>
: </html>
:
: Any and All help is appreciated,
:
: Kyle
:
|
|
|
View Cart
