I would greatly appreciate help with this problem.



I have been trying to save a large text BLOB to a SQL Server 7 (data type 

= text) field using a stored procedure.  This works fine for string 

lengths <= 8000, but fails for longer text messages.  The code that I have 

been using to create and load the paramenter follows: 



Set objQtOrdHTML = Server.CreateObject("ADODB.Parameter")

objQtOrdHTML.Name = "@quote_order_html"

objQtOrdHTML.Type = adLongVarChar    '(use adLongVarChar for text BLOBs)

objQtOrdHTML.Direction = 1

objQtOrdHTML.Attributes = adParamLong

objQtOrdHTML.Size = LenB ( sQuoteOrderHTML ) 

objQtOrdHTML.Value = sQuoteOrderHTML



I noticed a note looking around ASP Today that mentioned a stream object 

in ADO 2.6 which I am using.  Can this be applied to stored procs?



Thanks in advance,



Rai Bianchi