Hello,
Charles Urbina said the following on 18.04.2006 17:57:
> [FbException (0x80004005): Dynamic SQL Error
> parameter mismatch for procedure INSERT_RESERVATION]
It is the cause of error.
Replace this:
> FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
> INSERT_RESERVATION", myConnecti
You can do in this way too...
FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION(?,?)", myConnection, myTransaction);
On 4/18/06, Carlos Guzmán Álvarez <[EMAIL PROTECTED]> wrote:
> Hello:
> > FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
> > INSERT_RESERVATION", m
Hello:
FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION", myConnection, myTransaction);
myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,
"COMPANY_NAME").Direction = ParameterDirection.Input;
myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar
PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Charles Urbina
Sent: Tuesday, April 18, 2006 5:57
PM
To: firebird-net-provider@lists.sourceforge.net
Subject: [Firebird-net-provider]
Executing Procedure Error Help Please!
Hello everyone!
I'm using version 2 RC1 of the .NET
Hello,
Charles Urbina said the following on 18.04.2006 17:57:
> [FbException (0x80004005): Dynamic SQL Error
> parameter mismatch for procedure INSERT_RESERVATION]
It is the cause of error.
Replace this:
> FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
> INSERT_RESERVATION", myConnecti
PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
Charles UrbinaSent: 18 April 2006 16:57To:
firebird-net-provider@lists.sourceforge.netSubject:
[Firebird-net-provider] Executing Procedure Error Help
Please!
Hello everyone!
I'm using version 2 RC1 of the .NET FB Provider
Hello everyone!
I'm using version 2 RC1 of the .NET FB Provider and VS 2005
I'm trying to execute a procedure but i get an error. (please see below)
my stored procedure need to return a parameter. I have taking off the return parameter from the stored procedure because I thoght that was the c
