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 ; )
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top