Click here to Skip to main content
16,019,018 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Peace be upon you all ....
i have a simple asp.net website page that show how to use ajax to display visitors comments. It uses sql server , but for many reasons i want to change the datasource so it uses Access instead. I tried that many times but every time i get errors. This one of them

((Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12031))


this the original website....
http://www.mediafire.com/?zyg2nxwynyu[^]
i need to add this code to my website ....

could any one help ?? :(( ;)
Posted
Updated 28-Jan-11 18:14pm
v8
Comments
TheyCallMeMrJames 8-Jul-10 10:27am    
Just an FYI...you won't likely get much help in a 'Quick Answers' forum when your question involves downloading files. Clarify what is throwing that error and post a bit a code in your questions so folks can see what's going on. Cheers.
R. Giskard Reventlov 9-Jul-10 11:51am    
Do not create an answer to respond to an answer or comments - alter your original post to reflect any changes.

it very very simple code, here it's

<
XML
<asp:ScriptManager ID="ScriptManager1" runat="server" />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:FormView ID="FormView1" runat="server" DataSourceID="SqlDataSource1" DefaultMode="Insert">
<InsertItemTemplate>
Name: <asp:TextBox ID="txtName" runat="server" Text='<%# Bind("name") %>'></asp:TextBox><br />
Comments:<br />
<asp:TextBox ID="txtComments" runat="server" Text='<%# Bind("comments") %>'
TextMode="MultiLine" Rows="4" Columns="50"></asp:TextBox><br />
<asp:HiddenField ID="hidTimeDate" runat="server" Value='<%# Bind("date") %>' />
<asp:Button ID="butSubmit" runat="server" CommandName="Insert" Text="Submit" />
</InsertItemTemplate>
</asp:FormView>
    <asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1"
        BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
        CellPadding="3" CellSpacing="2" Width="806px">
        <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
        <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
        <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
        <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
    </asp:GridView>
</ContentTemplate>
</asp:UpdatePanel>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
        ConnectionString="<%$ ConnectionStrings:CommentConnectionString %>"
        InsertCommand="INSERT users (name,comments,date) VALUES (@name, @comments, @date)"
        SelectCommand="SELECT name,comments,date FROM users">
        <InsertParameters>
            <asp:Parameter Name="name" />
            <asp:Parameter Name="comments" />
            <asp:Parameter Name="date" />
        </InsertParameters>
    </asp:SqlDataSource>

>

so what i want is to replace sqldatasource with accessdata sourdce,
 
Share this answer
 
Do you have the requisite permissions to open the Access database?

Have you googled on the exception code you're getting?

What happens if you debug? Where does it fail?

Just a few things to try.
 
Share this answer
 
thanx mr digital man , about your quetions , you can see the
code above. It's very simple as u can see. When a debug it some
times i got the page, but when i try to post a comment i get
the error in my first post. another times it gives me error
that i can't set access database ,because it's set automatically or something like that. I want someone to try changing the code. To see what is the problem exactly. I wouldn't ask such request if it was long code just because it's easy and simple. Thanx
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900