I have a stored procedure which I am passing in a parameter which is specified as text. The problem is that the command object parameter object is not detecting the text field, the text field in my stored procedure is being interpreted as a varchar.

Any Ideas as what could be causing this.




CREATE PROCEDURE sp_Bannanas
@text text

as ....

I have a visual basic routine which populates a command parameters object i.e.
Set Qy = New ADODB.Command
Set objCN = New ADODB.Connection
objCN.Commandtimeout = Commandtimeout
objCN.CursorLocation = adUseClient
objCN.Open strDSN
Set Qy.ActiveConnection = objCN
Qy.Commandtimeout = Commandtimeout
Qy.CommandType = adCmdStoredProc
Qy.CommandText = "sp_Bannanas"

I then populate the command paramters e.g.
For Each param In parameters
If param.Type = adLongVarBinary Or param.Type = adLongVarWChar Then
AddChunk param, vntValue

end if
next

Regards

Mike