ASP.NET Runtime Error problem

WebMSTR · Apr 28, 2012

//Note the would not help me in the database forum so i came here Hi, I have this ASP.NET, ADO.NET connecting to an Access database but I am having problem it seems that I cannot connect to the databass (access database). I keep receiving an Runtime Error after I click on the sub routine (Button_Click). But I dont know what is wrong with it or how to fix it. I cant get custom errors (or any errors- except for : Runtime on the webhost I signed up with. The script is..... <%@ Import Namespace="System.Data" %> <%@ Import Namespace="System.Data.OleDb" %> <%@ Page Language="VB" Debug="true" %> <Script Runat="Server"> Sub Button_Click(s as Object, e as EventArgs) Dim conServices as OleDbConnection Dim strInsert as String Dim cmdInsert as OleDbCommand conServices = New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=/databases/services.mdb") strInsert = "Insert Into Services (first_name,last_name) Values ("'txtFirstname.Text'","'txtLastname.Text'")" cmdInsert = New OleDbCommand(strInsert, conServices) conServices.Open() cmdInsert.ExecuteNonQuery() conservices.Close() Response.Redirect("http://www.msn.com") End Sub </Script> <html> <head><title>Submit Form</title></head> <body> <form runat="Server"> first Name: <asp:TextBox id="txtFirstname" runat="Server" /> Last Name: <asp:TextBox id="txtLastname" runat="Server" /> <asp:Button Text="Submit" OnClick="Button_Click" Runat="Server" /> </form> </body> </html> I would appreate any help. Thank you Are you sure that your webhost supports .NET? Reason I ask, is that since it's still Beta tech....Very few do.Hello Xanderno, Yes. My web host supports ASP.NET. My webhost provider is... http://www.webhost4life.com they are using Beta 2 They are a very good host and cheap prices. If you have any idea what is wrong with my script please let me know because I have been working on it for 3 days now and no luck. Thanks Xanderno1) You don't have the entire db path. If the path isn't C:databasesservices.mdb, this will cause a problem. Do a Server.MapPath to find out what the path should be, if you don't know it. 2)You have a problem with the insert statement. It should look like so: strInsert = "Insert Into Services (First_Name,Last_Name) Values ('" & txtFirstname.Text & "','" & txtLastname.Text & "')" That should fix you up.

ASP.NET Runtime Error problem

WebMSTR

New Member