Menu
▾
▴
firebird-net-provider
|
From: Charles U. <cha...@ho...> - 2006-04-18 14:57:18
|
<html><div style='background-color:'><DIV class=RTE>Hello everyone!</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>I'm using version 2 RC1 of the .NET FB Provider and VS 2005</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>I'm trying to execute a procedure but i get an error. (please see below)</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>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. </DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Tia</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>Charles</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>--------------- Error -----------------------</DIV>
<DIV class=RTE>
<H2><I>Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.</I> </H2><FONT face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif "><B>Description: </B>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. <BR><BR><B>Exception Details: </B>FirebirdSql.Data.Common.IscException: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.<BR><BR><B>Source Error:</B> <BR><BR>
<TABLE width="100%" bgColor=#ffffcc>
<TBODY>
<TR>
<TD><CODE><PRE>Line 152:
Line 153: // Execute Update
<FONT color=red>Line 154: myCommand.ExecuteNonQuery();
</FONT>Line 155:
Line 156: // Commit changes</PRE></CODE></TD></TR></TBODY></TABLE><BR><B><FONT face=Verdana>Source File: </FONT></B>c:\2005 Projects\Star Net Limo\StarsLimoWebSite\Reservations.aspx.cs<B><FONT face=Verdana> Line: </FONT></B>154 <BR><BR><B><FONT face=Verdana>Stack Trace:</FONT></B> <BR><BR>
<TABLE width="100%" bgColor=#ffffcc>
<TBODY>
<TR>
<TD><CODE><PRE>[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.IPostBackEventHandler.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
</PRE></CODE></TD></TR></TBODY></TABLE><BR>
<HR width="100%" color=silver SIZE=1>
<B><FONT face=Verdana>Version Information:</FONT></B> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42 </FONT><!--
[IscException]: Exception of type 'FirebirdSql.Data.Common.IscException' was thrown.
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadStatusVector()
at FirebirdSql.Data.Client.Gds.GdsConnection.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsDatabase.ReadResponse()
at FirebirdSql.Data.Client.Gds.GdsStatement.Prepare(String commandText)
at FirebirdSql.Data.FirebirdClient.FbCommand.Prepare(Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteCommand(CommandBehavior behavior, Boolean returnsSet)
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
[FbException]: Dynamic SQL Error
parameter mismatch for procedure INSERT_RESERVATION
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery()
at Reservations.ASPxButton4_Click(Object sender, EventArgs e) in c:\2005 Projects\Star Net Limo\StarsLimoWebSite\Reservations.aspx.cs:line 154
at DevExpress.Web.ASPxDataControls.ASPxButton.OnClick(EventArgs e)
at DevExpress.Web.ASPxDataControls.ASPxButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
[HttpUnhandledException]: Exception of type 'System.Web.HttpUnhandledException' was thrown.
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.reservations_aspx.ProcessRequest(HttpContext context) in c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\starslimowebsite\65f21fa1\b9a34f6f\App_Web_u48lmxu4.0.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
--></DIV>
<DIV class=RTE>----------------------------------------------</DIV>
<DIV class=RTE> </DIV>
<DIV class=RTE>------------------------- My Code ------------------------</DIV>
<DIV class=RTE><FONT color=#0000ff size=2>
<P>protected</FONT><FONT size=2> </FONT><FONT color=#0000ff size=2>void</FONT><FONT size=2> ASPxButton4_Click(</FONT><FONT color=#0000ff size=2>object</FONT><FONT size=2> sender, </FONT><FONT color=#008080 size=2>EventArgs</FONT><FONT size=2> e)</P>
<P>{</P>
<P></FONT><FONT color=#0000ff size=2>string</FONT><FONT size=2> connectionString =</FONT><FONT color=#800000 size=2>"Database=C:\\2005 Projects\\Star Net Limo\\Database\\STARSNETLIMO.FDB;"</FONT><FONT size=2> + </FONT><FONT color=#800000 size=2>"User=SYSDBA;"</FONT><FONT size=2> + </FONT><FONT color=#800000 size=2>"Password=masterkey;"</FONT><FONT size=2> + </FONT><FONT color=#800000 size=2>"Dialect=3;"</FONT><FONT size=2> + </FONT><FONT color=#800000 size=2>"Server=localhost"</FONT><FONT size=2>;</FONT></P>
<P><FONT color=#008080 size=2>FbTransaction</FONT><FONT size=2> myTransaction;</P>
<P></FONT><FONT color=#008080 size=2>FbConnection</FONT><FONT size=2> myConnection = </FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2> </FONT><FONT color=#008080 size=2>FbConnection</FONT><FONT size=2>(connectionString);</P>
<P>myConnection.Open();</P>
<P>myTransaction = myConnection.BeginTransaction();</P>
<P></FONT><FONT color=#008080 size=2>FbCommand</FONT><FONT size=2> myCommand = </FONT><FONT color=#0000ff size=2>new</FONT><FONT size=2> </FONT><FONT color=#008080 size=2>FbCommand</FONT><FONT size=2>(</FONT><FONT color=#800000 size=2>"EXECUTE PROCEDURE INSERT_RESERVATION"</FONT><FONT size=2>, myConnection, myTransaction);</P>
<P>myCommand.Parameters.Add(</FONT><FONT color=#800000 size=2>"@COMPANY_NAME"</FONT><FONT size=2>, </FONT><FONT color=#008080 size=2>FbDbType</FONT><FONT size=2>.VarChar, 100, </FONT><FONT color=#800000 size=2>"COMPANY_NAME"</FONT><FONT size=2>).Direction = </FONT><FONT color=#008080 size=2>ParameterDirection</FONT><FONT size=2>.Input;</P>
<P>myCommand.Parameters.Add(</FONT><FONT color=#800000 size=2>"@PASSENGER_NAME"</FONT><FONT size=2>, </FONT><FONT color=#008080 size=2>FbDbType</FONT><FONT size=2>.VarChar, 100, </FONT><FONT color=#800000 size=2>"PASSENGER_NAME"</FONT><FONT size=2>).Direction = </FONT><FONT color=#008080 size=2>ParameterDirection</FONT><FONT size=2>.Input;</P>
<P>myCommand.Parameters[0].Value = txCompanyName.Text;</P>
<P>myCommand.Parameters[1].Value = txPassengerName.Text;</P>
<P></FONT><FONT color=#008000 size=2>// Execute Update</P></FONT><FONT size=2>
<P>myCommand.ExecuteNonQuery();</P>
<P></FONT><FONT color=#008000 size=2>// Commit changes</P></FONT><FONT size=2>
<P>myTransaction.Commit(); </P>
<P></P>
<P></FONT><FONT color=#008000 size=2>// Free command resources in Firebird Server</P></FONT><FONT size=2>
<P>myCommand.Dispose();</P>
<P></FONT><FONT color=#008000 size=2>// Close connection</P></FONT><FONT size=2>
<P>myConnection.Close();</P>
<P>}</P></FONT></DIV>
<DIV class=RTE>---------------------------------------------------------------</DIV></div></html>
|
|
From: Yvan P. <yva...@co...> - 2006-04-18 15:11:41
|
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 when I try to introduce a new connection with the
Visual Studio wizard:
"Failure has occured while loading a type"
I could not find how you have solved that problem into the mails archive.
Could you please help me ?
Regards
Yvan
-----Original Message-----
From: fir...@li...
[mailto:fir...@li...]On Behalf Of
Charles Urbina
Sent: 18 April 2006 16:57
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.IPostBackEventHa
ndler.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
|
|
From: Oleg D. <thi...@td...> - 2006-04-18 15:12:24
|
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, myTransaction);
with something like this:
FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION(@COMPANY_NAME, @PASSENGER_NAME)", myConnection,
myTransaction);
--
Oleg
|
|
From: Paul M. <pau...@al...> - 2006-04-18 15:16:39
|
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
|
|
From:
<car...@te...> - 2006-04-18 17:08:57
|
Hello:
> FbCommand myCommand =3D new FbCommand("EXECUTE PROCEDURE=20
> INSERT_RESERVATION", myConnection, myTransaction);
>
> myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,=20
> "COMPANY_NAME").Direction =3D ParameterDirection.Input;
>
> myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,=20
> "PASSENGER_NAME").Direction =3D ParameterDirection.Input;
>
As people has told you yet or you put the parameters in tthe command=20
text, or, you can do this:
FbCommand myCommand =3D new FbCommand("INSERT_RESERVATION", myConnection,=
=20
myTransaction);
myCommand.CommandType =3D CommandType.StoredProcedure;
myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,=20
"COMPANY_NAME").Direction =3D ParameterDirection.Input;
myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,=20
"PASSENGER_NAME").Direction =3D ParameterDirection.Input;
--=20
Carlos Guzm=E1n =C1lvarez
Vigo-Spain
http://carlosga.blogspot.com/
"When you don't code, you tend to become one of those architects who thin=
ks everything is possible" ( Anders Hejlsberg )
|
|
From: Eduardo B. <edu...@gm...> - 2006-04-18 18:44:51
|
You can do in this way too...
FbCommand myCommand =3D new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION(?,?)", myConnection, myTransaction);
On 4/18/06, Carlos Guzm=E1n =C1lvarez <car...@te...> wrote:
> Hello:
> > FbCommand myCommand =3D new FbCommand("EXECUTE PROCEDURE
> > INSERT_RESERVATION", myConnection, myTransaction);
> >
> > myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,
> > "COMPANY_NAME").Direction =3D ParameterDirection.Input;
> >
> > myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,
> > "PASSENGER_NAME").Direction =3D ParameterDirection.Input;
> >
>
> As people has told you yet or you put the parameters in tthe command
> text, or, you can do this:
>
> FbCommand myCommand =3D new FbCommand("INSERT_RESERVATION", myConnection,
> myTransaction);
> myCommand.CommandType =3D CommandType.StoredProcedure;
> myCommand.Parameters.Add("@COMPANY_NAME", FbDbType.VarChar, 100,
> "COMPANY_NAME").Direction =3D ParameterDirection.Input;
> myCommand.Parameters.Add("@PASSENGER_NAME", FbDbType.VarChar, 100,
> "PASSENGER_NAME").Direction =3D ParameterDirection.Input;
>
>
>
> --
> Carlos Guzm=E1n =C1lvarez
> Vigo-Spain
>
> http://carlosga.blogspot.com/
>
> "When you don't code, you tend to become one of those architects who thin=
ks everything is possible" ( Anders Hejlsberg )
>
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by xPML, a groundbreaking scripting langua=
ge
> that extends applications into web and mobile media. Attend the live webc=
ast
> and join the prime developer group breaking into this new coding territor=
y!
> http://sel.as-us.falkag.net/sel?cmdlnk&kid=110944&bid$1720&dat=121642
> _______________________________________________
> Firebird-net-provider mailing list
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>
--
----------------------------------------------------------
"I throw myself into the sea
Release the wave, let it wash over me
To face the fear I once believed
The tears of the dragon, for you and for me"
Bruce Dickinson - Tears of the Dragon
=A7=80NT=80NC=80=D0 - MSN - sir...@ho...
edu...@gm...
----------------------------------------------------------
|
|
From: Oleg D. <ol...@td...> - 2006-04-18 15:11:46
Attachments:
smime.p7s
|
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, myTransaction);
with something like this:
FbCommand myCommand = new FbCommand("EXECUTE PROCEDURE
INSERT_RESERVATION(@COMPANY_NAME, @PASSENGER_NAME)", myConnection,
myTransaction);
--
Oleg
|
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X