sp data type error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

sp data type error

Author

Topic

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-02-15 : 16:43:02

I got run-time error 3421 on the line .parameters append.
The field in the table is varchar(15). I declared @Jno as the same type in sp. I had another similar sp which takes integer that runs fine. What is the trick here? Thanks for any help!

Dim strInput As String
strInput = txtJobGang
Set cn = New ADODB.Connection
cn.CursorLocation = adUseClient
cn.Open conDevConnetionString
Set cmd = New ADODB.Command
With cmd
Set .ActiveConnection = cn
.CommandType = adCmdStoredProc
.CommandText = "OP_getJob"
.Parameters.Append cmd.CreateParameter("@Jno", adVarChar, adParamInput, 4, strInput)
'data type error run-time 3421
Set rs = cmd.Execute
End With

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-02-15 : 17:49:01

try
.Parameters.Append cmd.CreateParameter("@Jno", adVarChar, adParamInput, 15, strInput)

Go with the flow & have fun! Else fight the flow

Hommer
Aged Yak Warrior

808 Posts

Posted - 2005-02-15 : 17:49:43

I got it.

Thanks!!!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources