I&#039m trying to pass user-entered text input to a stored procedure using the Parameters collection. This technique is working for nvarchar datatypes (in SQLServer7), but not for the text datatype.<BR><BR>Can anyone help me match a SqlServer7 datatype of Text with a<BR>adDataType constants used with the Parameters Collection of the ADO Command object? There seems to be no direct match. Is there a way of not specifying the Type?<BR><BR>I&#039m using the CreateParameter method:<BR><BR>Set Parameter = Command.CreateParameter (Name, [Type], [Direction], [Size], [Value])<BR><BR>I&#039m also open to other suggestions if updating data this way isn&#039t appropriate. The text entered is roughly 3-5 paragraphs in length.<BR><BR>Thanks!