Stored Procedure parameter problem

[einhugur]

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

[Lothar Haensler]

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

[al_paso]

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