RE: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Yvan Pochon
[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 and VS 200

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Oleg Deribas
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, myConnection,

RE: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Paul Mercea
] [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 FB Provider and VS

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Carlos Guzmán Álvarez
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, 100,

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Eduardo Beninca
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,

Re: [Firebird-net-provider] Executing Procedure Error Help Please!

2006-04-18 Thread Oleg Deribas
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, myConnection,