80004005; Error in Row

[LongFeiFengWu]

Here is the asp code i'm using:

<!--#Include file=&quot;Includes/openDBconnections.asp&quot; -->
<%

objrec.open &quot;Comments&quot;,objcon,3,3

objrec.addnew

objrec(&quot;Date&quot = Date
objrec(&quot;VZID&quot = request.cookies(&quot;ECT&quot(&quot;VZID&quot
objrec(&quot;Type&quot = request.form(&quot;Type&quot
objrec(&quot;FirstName&quot = request.cookies(&quot;FirstName&quot
objrec(&quot;LastName&quot = request.cookies(&quot;LastName&quot
objrec(&quot;Subject&quot = request.form(&quot;Category&quot
objrec(&quot;Comments&quot = request.form(&quot;Comments&quot
objrec(&quot;eGain&quot = request.form(&quot;eGain&quot
objrec(&quot;Customer&quot = request.form(&quot;Sent&quot

Objrec.update

%>
<!--#Include file=&quot;Includes/closeDBconnections.asp&quot; -->

For some reason, I'm getting the following error:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver]Error in row
/nuzbitz/Joe/CommentSubmit.asp, line 18

Any ideas? I'm going batty here.

Thanks in advance,

Joseph

 

[manjulam]

Maybe some of the fields are not getting filled and it cannot accept zero lengths in the database. Check that.

It is always better to use the direct method than looping thru the recordset .

 

[TonyU]

[tt]check the link below

Got ASP Error(s)? =

http://www.aspfaq.com

​

 

[Falcon99]

I'm not sure what is in your includes files.

Include files get processed before any ASP code gets processed.

It would be better to have the one include file contain your open and close functions, then call the functions in your code as needed.

HTH