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", myConnecti

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", m

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

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

2006-04-18 Thread Paul Mercea
Hi I think here is your problem: FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE INSERT_RESERVATION", myConnection, myTransaction); You need to specify parameters to for that procedure INSERT_RESERVATION(@parameter,@parameter2)   C y PaulM   From: [EMAIL PROTECTED] [m

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", myConnecti

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

2006-04-18 Thread Yvan Pochon
Hello Charles, I could not give you any advise on your current problem because I just start to use VS C# !!!   However looking at the archived mails, I have notice that you had the same problem I am facing now. After installation of the Firebird .NET provider I get the following message whe