ERROR : Microsoft OLE DB Provider for ODBC Drivers error '80040e10

A

AQ

HI, could anybody please sehd some light on this error for me plese, ive been
trying to figure it out for the last few days.... going crazy!!

Im getting the following error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e10'
[Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
/Thank_Service_Engineer.asp, line 369


Here's a snipet of my code and the line 369 with the error


Dim adoCon
Dim rsAddComments
Dim strSQL


Session("DatabasePath") = Server.Mappath("complete.mdb")
Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & Session("DatabasePath") & ";"

Set rsAddComments = Server.CreateObject("ADODB.Recordset")

strSQL="SELECT Reports.ID_no, Reports.Engineer, Reports.DateCompleted,
Reports.Comment, Reports.Hours FROM Reports;"
'strSQL="SELECT * FROM Reports;"

rsAddComments.CursorType = 2
rsAddComments.LockType=3

rsAddComments.Open strSQL, adoCon // error on this line 369

rsAddComments.AddNew
rsAddComments.Fields("ID_no")=Request.Form("ID_no")
rsAddComments.Fields("Engineer")=Request.Form("Engineer")
rsAddComments.Fields("DateCompleted")=Request.Form("DateCompleted")
rsAddComments.Fields("Comment")=Request.Form("Comment")
rsAddComments.Fields("Hours")=Request.Form("Hours")
rsAddComments.Update

on error resume next
adoCon.Execute sql,recaffected

__________________________________________________________________

All suggestions greatly appreciated,

Thanx ; )
 
Top