Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_database_setup thread: error '80004005'


Message #1 by "Tonya O'Donnell" <tonya@b...> on Mon, 17 Mar 2003 19:32:25
when i try to add a new entry i get this error

what have i done wrong 

here is the code: i have checked form & all form fields are named 
correctly !!!

<%
Dim myConn 		'Database Connection Variable
Set myConn = Server.CreateObject("ADODB.Connection")
myConn.Open "tonya"

Dim myRS
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "journal", myConn, adOpenKeyset, adLockOptimistic
myRS.AddNew
myRS("date") = Request.Form("date")
myRS("title") = Request.Form("title")
myRS("text") = Request.Form("text")
myRS("pic") = Request.Form("pic")
myRS.Update
myRS.Close
Set myRS = Nothing
myConn.Close
Set myConn = Nothing
%>
<p>Record added.<br>

  Return to Index