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