Re: What's wrong ...man...

From: Tim (Tim_at_NoSpam)
Date: 05/19/04 

Date: Wed, 19 May 2004 19:52:31 +1200

And... how many parameters does it have?
- Tim

"Utada P.W. SIU" <wing0508@hotmail.com> wrote in message
news:uTKhwqWPEHA.3452@TK2MSFTNGP10.phx.gbl...
>I am using stored procedure in my Visual Basic program
>
> however, when I call it from program, it prompt me following error:
> Run-time error '-2147217900 (80040e14)':
> Syntax error or access violation
>
> Here a piece of code in my vb program
>
> '-- getConnection is a valid function that return a ADODB.Connection
> object
> '-- getCommand also a valid function, xp_getExtractHistory is the stored
> procedure name
> Set connection = getConnection()
> Set command = getCommand("xp_getExtractHistory", connection)
>
> With command
> .Parameters.Append .CreateParameter("@orderField", adVarWChar,
> adParamInput, 20, order_by)
> End With
>
> And here have some piece of my sp program
>
> CREATE PROCEDURE xp_getExtractionHistory
> @orderField VARCHAR(20),
> @sortOrder CHAR(1)
> AS
> :
> :
>
> what's wrong....thanks~
>
>
>

Relevant Pages