Command Object Problem, Please help!

[GDX]

I get the followig error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

Errors occurred

/testnotes.asp, line 27


I dont really understand why I get this error it seems like everything is defined properly take a look at the ASP Coding:

ocommand = Server.CreateObject ("Adodb.Command&quot
ocommand.ActiveConnection = Connstring;
ocommand.CommandType = 4;
ocommand.CommandText = "INTRAK.PL_NOTES_UPDATE"
ocommand.Parameters.Append (ocommand.CreateParameter("nType",131,1,50,"1&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("nReturn",131,2,50,"0&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("nNoteId",131,2,50,"5&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("nUserId",131,1,50,"196&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("cLotno",200,1,50,"1&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("cProdId",200,1,50,"GGG&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("cCustId",200,1,50,"Xiacon&quot)
ocommand.Parameters.Append (ocommand.CreateParameter("cNotes",200,1,50,"dsfsdfsd sdfsdfsdfd&quot)
ocommand.execute ("INTRAK.PL_NOTES_UPDATE&quot

Here is how the data is defined within the stored proc:


nType IN number,
nUserId IN NUMBER,
nReturn IN OUT Number,
nNoteId IN OUT Number,
cLotno IN varchar2,
cProdId IN varchar2,
cCustId IN varchar2,
cNotes IN blob


Can someone pleaseeee help me?
Gordon R. Durgha
gd@vslink.net

http://www.vslink.net

http://www.brainbench.com/transcript.jsp?pid=1217371

 

[lobstah]

From:

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP

Error Message
Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Errors occurred
Cause
This may be caused by trying to insert more data into a field than is allowed. For example, inserting 26 characters into a Microsoft Access field that is formatted to accept only 25 characters.

Could this be the problem?