Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: '80004005 Error in row '


Message #1 by "Mark MacInnes" <mark.macinnes@l...> on Sat, 18 Jan 2003 16:37:30
Hi,

I've been working on a newsletter application. I have used this script 
many times, but it's not working on this page for some unknown reason, 
returning:

--------------------
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 

[Microsoft][ODBC Microsoft Access Driver]Error in row 

/lf_newsletter/lf_nl_send.asp, line 29 
--------------------

The script i'm using is:

--------------------
connLF_NL = "DSN=LF_Newsletter"
'Add newsletter to database
'Open connection	
Set objConnAdd = Server.CreateObject("ADODB.Connection")
Set objRSAdd = Server.CreateObject("ADODB.RecordSet")
objConnAdd.Open connLF_NL
'Add to database
objRSAdd.Open "SELECT * FROM email", objConnAdd, 3, 3
objRSAdd.AddNew 
objRSAdd.Fields("strTitle") = strTitle
objRSAdd.Fields("strContent") = strContent
objRSAdd.Fields("datDate") = Date()
objRSAdd.Fields("datTime") = Time()
objRSAdd.Fields("strUser") = strUser
objRSAdd.Update
--------------------

I've spent ages searching for answers but can't find anything.

Thanks in advance!

Mark MacInnes

  Return to Index