[ASP] Adding A record to the Database

I need help with this code I keep doing it and just getting a http 500

Page 1 of 1

2 Replies - 952 Views - Last Post: 02 October 2009 - 04:54 AM Rate Topic: -----

#1 Glorfindal  Icon User is offline

  • Java Enthusiast
  • member icon

Reputation: 37
  • View blog
  • Posts: 606
  • Joined: 31-December 08

[ASP] Adding A record to the Database

Posted 01 October 2009 - 05:14 PM

I need help with this code I keep doing it and just getting a HTTP 500 INTERNAL SERVER ERROR.
//*Created by Glorfindal Sept 15, 2009
//*ASP START*
<%
//Create Connection to database.
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.open "C:/inetpub/wwwroot/DragonKwest.mdb"  'Database Directory

//Save Data to Database.
sql="INSERT INTO User_Accounts (Login,"
sql=sql & "Password,Email,Code)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("Heroname") & "',"
sql=sql & "'" & Request.Form("pass") & "',"
sql=sql & "'" & Request.Form("email") & "',"
sql=sql & "'" & Request.Form("humveri") & "')"
conn.Execute sql,recaffected
conn.close
%>
//*ASP END*



Is This A Good Question/Topic? 0
  • +

Replies To: [ASP] Adding A record to the Database

#2 Jayman  Icon User is offline

  • Student of Life
  • member icon

Reputation: 421
  • View blog
  • Posts: 9,532
  • Joined: 26-December 05

Re: [ASP] Adding A record to the Database

Posted 01 October 2009 - 05:25 PM

Verify that you are using the correct connection string for Access here, I think you will find that is where the problem is.
Was This Post Helpful? 0
  • +
  • -

#3 Glorfindal  Icon User is offline

  • Java Enthusiast
  • member icon

Reputation: 37
  • View blog
  • Posts: 606
  • Joined: 31-December 08

Re: [ASP] Adding A record to the Database

Posted 02 October 2009 - 04:54 AM

Yeah but I don't need the thing protected with a username or password.
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1