What's wrong ...man...

From: Utada P.W. SIU (wing0508_at_hotmail.com)
Date: 05/19/04 

Date: Wed, 19 May 2004 14:29:54 +0800

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

  • Re: Timeout problem, please help - Stored procedure.sql [0/1]
    ... > My C# code call a stored procedure that is used to normalize a database ... > The stored procedure works fine in SQL analyzer, but when I try to use ... > must normalize) but I don't know what I must do to work with my stored ... I tried to set connection timeout=600 but after 2 ...
    (microsoft.public.dotnet.framework.adonet)
  • Timeout problem, please help - Timeout problem.zip [0/1]
    ... My C# code call a stored procedure that is used to normalize a database ... The stored procedure works fine in SQL analyzer, but when I try to use ... I tried to set connection timeout=600 but after 2 ...
    (microsoft.public.dotnet.framework.adonet)
  • Timeout problem, please help - Stored procedure.sql [0/1]
    ... My C# code call a stored procedure that is used to normalize a database ... The stored procedure works fine in SQL analyzer, but when I try to use ... I tried to set connection timeout=600 but after 2 ...
    (microsoft.public.dotnet.framework.adonet)