Passing VARBINARY/BINARY param to a stored proc
From: Chris (chrisx_at_NOSPAM.com)
Date: 08/20/04
- Next message: Jerry Pisk: "Re: Hot fix needed"
- Previous message: gbsBPS_at_nospam.nospam: "Hot fix needed"
- Next in thread: William \(Bill\) Vaughn: "Re: Passing VARBINARY/BINARY param to a stored proc"
- Reply: William \(Bill\) Vaughn: "Re: Passing VARBINARY/BINARY param to a stored proc"
- Reply: Doug Stoltz: "Re: Passing VARBINARY/BINARY param to a stored proc"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 20 Aug 2004 16:11:57 +0100
My VB6 program is having problems using ADO (2.7) to pass a Byte array to a
VARBINARY parameter in an SQL Server 2000 stored procedure. I get an error
"3421:Application uses a value of the wrong type for the current operation"
when calling the Execute method.
If I set Parameter(2).Value = Null then everything works OK. I've confirmed
that I'm updating the correct ADOParameter. Prior to calling Execute, the
Value is an array. I've even commented out the stored procedure code so
that the parameter is ignored. Can someone point me in the right direction
please?
My code is as follows:-
Dim vData() As Byte
Dim Proc As Command
// Code to redimension & populate vData()...
Set Proc = New ADODB.Command
With Proc
Set .ActiveConnection = myDatabase.Connection
.CommandText = "MY_PROCEDURE"
.CommandType = adCmdStoredProc
.Parameters(1).Value = 1
.Parameters(2).AppendChunk vData()
.Execute
End With
- Next message: Jerry Pisk: "Re: Hot fix needed"
- Previous message: gbsBPS_at_nospam.nospam: "Hot fix needed"
- Next in thread: William \(Bill\) Vaughn: "Re: Passing VARBINARY/BINARY param to a stored proc"
- Reply: William \(Bill\) Vaughn: "Re: Passing VARBINARY/BINARY param to a stored proc"
- Reply: Doug Stoltz: "Re: Passing VARBINARY/BINARY param to a stored proc"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
