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

[Paul M. <pau...@al...>]

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: fir...@li...
[mailto:fir...@li...] On Behalf Of
Charles Urbina
Sent: Tuesday, April 18, 2006 5:57 PM
To: fir...@li...
Subject: [Firebird-net-provider] Executing Procedure Error Help Please!

 

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 cause of
the error but the problem is the same. 

 

Tia

 

Charles

 

--------------- Error -----------------------


Exception of type 'FirebirdSql.Data.Common.IscException' was thrown. 


Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code. 

Exception Details: FirebirdSql.Data.Common.IscException: Exception of type
'FirebirdSql.Data.Common.IscException' was thrown.

Source Error: 


Line 152:
Line 153:            // Execute Update
Line 154:            myCommand.ExecuteNonQuery();
Line 155:
Line 156:            // Commit changes


Source File: c:\2005 Projects\Star Net
Limo\StarsLimoWebSite\Reservations.aspx.cs    Line: 154 

Stack Trace: 


[IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was
thrown.]
   FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector() +866
   FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse() +107
   FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse() +14
   FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String commandText) +247
   FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
+309
   FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior
behavior, Boolean returnsSet) +17
   FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() +53
 
[FbException (0x80004005): Dynamic SQL Error
parameter mismatch for procedure INSERT_RESERVATION]
   FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() +127
   Reservations.ASPxButton4_Click(Object sender, EventArgs e) in c:\2005
Projects\Star Net Limo\StarsLimoWebSite\Reservations.aspx.cs:154
   DevExpress.Web.ASPxDataControls.ASPxButton.OnClick(EventArgs e) +75
 
DevExpress.Web.ASPxDataControls.ASPxButton.System.Web.UI.IPostBackEventHandl
er.RaisePostBackEvent(String eventArgument) +284
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler
sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +172
   System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4920

 

  _____  

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET
Version:2.0.50727.42 

----------------------------------------------

 

------------------------- My Code ------------------------

protected void ASPxButton4_Click(object sender, EventArgs e)

{

string connectionString ="Database=C:\\2005 Projects\\Star Net
Limo\\Database\\STARSNETLIMO.FDB;" + "User=SYSDBA;" + "Password=masterkey;"
+ "Dialect=3;" + "Server=localhost";

FbTransaction myTransaction;

FbConnection myConnection = new FbConnection(connectionString);

myConnection.Open();

myTransaction = myConnection.BeginTransaction();

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,
"PASSENGER_NAME").Direction = ParameterDirection.Input;

myCommand.Parameters[0].Value = txCompanyName.Text;

myCommand.Parameters[1].Value = txPassengerName.Text;

// Execute Update

myCommand.ExecuteNonQuery();

// Commit changes

myTransaction.Commit(); 

// Free command resources in Firebird Server

myCommand.Dispose();

// Close connection

myConnection.Close();

}

---------------------------------------------------------------

------------------------------------------------------- This SF.Net email is
sponsored by xPML, a groundbreaking scripting language that extends
applications into web and mobile media. Attend the live webcast and join the
prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________ Firebird-net-provider
mailing list Fir...@li...
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider