January 26, 2006 at 5:48 am
I'm trying to use adbstr in the parameter below but dont know if there is a set number.
cmd.Parameters.Append cmd.CreateParameter ("@newsText", adBSTR, adParamInput, 160000, newsText)
I'm not sure if the no. entered is correct what should it be.
Error msg
Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
[Microsoft][ODBC SQL Server Driver]String data, right truncation
/blctasp/addnewnewsletter.asp, line 38
January 27, 2006 at 8:08 am
See if this helps:
cmd.Parameters.Append cmd.CreateParameter ("@newsText", adBSTR, adParamInput, Len(newsText), newsText)
Also, as I mentioned in your other post, if you are calling a stored procedure that uses WRITETEXT, the length of the data stored in newsText is limited to around 120KB. To be safe, you should use a WHILE loop in the stored procedure and the UPDATETEXT statement instead to write newsText to the table in multiple blocks.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply