Help with error passing parameter!!

[MDA]

Hi all,

I have a small app that executes a stored procedure. I am getting an error only on certain databases and I cannot understand why! It seems to only show on SQL Server 7.0, have not seen it on SQL 2000 yet....

the error is:
..error 3421 method 'value' of object '_parameter' failed

I can't understand why the error is NOT consistant amongst all the databases I run the app on.

my VB parameters are:
---------------------
Set cmd.ActiveConnection = Cn
' Define the stored procedure.
cmd.CommandText = "sp_data_trans"
cmd.CommandType = adCmdStoredProc

' Set values to parameters, and execute the query.
cmd.Parameters("@NewTT&quot = frmMain.combotooTT.Text
cmd.Parameters("@OldTT&quot = frmMain.combofromTT.Text
cmd.Parameters("@StartPE&quot = frmMain.PEstart.Text
cmd.Parameters("@EndPE&quot = frmMain.PEend.Text
cmd.Parameters("@Journum&quot = frmMain.txtJour.Text
cmd.Parameters("@JourDesc&quot = frmMain.txtJourDesc.Text
cmd.Parameters("@NewTC&quot = frmMain.cmboJourTC.Text

Cn.CommandTimeout = 0
Set rs = cmd.Execute
---------------------------
In the Stored procedure I have:
....
@NewTT varchar(4), @OldTT varchar(4), @StartPE varchar(5), @EndPE varchar(5), @Journum integer, @jourDesc varchar(255), @NewTC varchar(4)
....
--------------------------

Any ideas why I amgetting this error??? I have read up on MSDN but could not find anything to solve this challenge.

Any help is greatly appreciated!!!

Best regards,

Mike

 

[MDA]

opps.. I figured it out... so easy yet-- took me an hour to realize. I was passing 5 letters to a variable that was only set to receive 2.

Problem solved..

Mike