MS Access DB, XP Pro and IIS 5.1...

  • Thread starter Thread starter Scott Starker
  • Start date Start date
S

Scott Starker

I am using MS Visual Web Developer 2005 Express Edition, MS Access DB, XP
Pro and IIS 5.1 on my local XP Pro.

This is a Newbie question with a very simple answer (I think). When I run
the page it loads up just fine (with all of DB fields in the dropdown boxes,
etc.). The problem is when I go to select an item from any of the dropdown
boxes the IE says, "Internet Explorer cannot display the webpage" and
FireFox says, "The connection to the server was reset while the page was
loading." I believe the error happens right after OnSelectedIndexChanged and
before Protected Sub cmbRecordLookup_SelectedIndexChanged(...) because the
program isn't getting to the breakpoint I put at the beginning of the Sub. I
have programmed four of the pages and three of them work. Strange... Here is
a part of my code:

<asp:DropDownList ID="cmbRecordLookup" Style="z-index: 201; left: 200px;
position: absolute; top: 203px" runat="server" Width="396px" Height="20px"
BackColor="Yellow" Font-Names="Doulos SIL" ForeColor="0"
DataSourceID="AccessDataSource1" DataTextField="forBookID"
OnSelectedIndexChanged="cmbRecordLookup_SelectedIndexChanged"
AutoPostBack="true" AppendDataBoundItems="True">
<asp:ListItem Value="-1">-- Choose a Book ID --</asp:ListItem>
</asp:DropDownList>

<asp:AccessDataSource ID="AccessDataSource1" runat="server"
DataFile="~/App_Data/pub_db_4_be.mdb" SelectCommand="SELECT Books.BookID &
Books.TitleNormalized & Languages.LanguageName & Languages.EthnologueCode AS
forBookID FROM Books INNER JOIN Languages ON
Languages.LanguageID=Books.LanguageID ORDER BY Books.BookID">
</asp:AccessDataSource>

What is happening and how should I do this? I would appreciate any help.

TIA

Scott
 
I'm having the same problem (though it only happens in FF for me). Page loads, everything is hunky dory until a postback. "Connection was reset" error is displayed. If you figure it out, let me know cmcbride _@_ kaplan.edu
 
I'm having the same problem (though it only happens in FF for me). Page loads, everything is hunky dory until a postback. "Connection was reset" error is displayed. If you figure it out, let me know cmcbride _@_ kaplan.edu
 
Chris,

I have solved it half-way. Comment all of your "postback" sections except
for one and run the asp.net. Now, do the "postback" and if it works go on to
the next one. Once you find that it will not work then I don't know what to
do. I have something wrong with my SELECT clause but I don't know what it
is...
 
Back
Top