Stored Procedure parameter problem

Hello

I'm having problems talking to the third parameter in the stored procedure header here bellow:

CREATE PROCEDURE [sp_AddToHistory_tblFileHistory]
(@lFileID [int],
@sUser [nvarchar](20),
@sComment [ntext],
@dtCheckedInTime [int])

Here is how I talk to the first

Set prmChecktblFiles = cmdChecktblFiles.CreateParameter( _
"lFileID", _
adBigInt, _
adParamInput, , _
lFileID)

If anyone knows how to create the parameter for the third, the please let me know

Thanks

I'd try to call cmd.Parameters.Refresh just for testing. Then check what the Parameters collection looks like for the third parameter.

I had the same problem with text fields in SQL server and I worked around by executing straightaway:

connection.execute sp_something param1, param2, param3