New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Executing Stored Procedure Fails with 'Stored Procedure doesn't exist' message [DNET517] #499
Comments
Commented by: Cecil Martin (rabbitdogs) Attached are database and project files |
Modified by: Cecil Martin (rabbitdogs)Attachment: SP_ERROR.zip [ 12364 ] |
Modified by: Cecil Martin (rabbitdogs)environment: Windows 8 Pro 64 bit, Visual Studio 2012 => Windows 8 Pro 64 bit, Visual Studio 2012. TARGET = NET4.0 |
Commented by: @cincuranet Calling your library and it works fine. The ExecuteNonQuery does not throw any exception. Though the "rv = CType(cm.Parameters.Item("@O_JOBQ_ID").Value, Guid)" does. Given that the error is from server and not client, I would say the SP really isn't in your database. |
Commented by: Cecil Martin (rabbitdogs) The database file sent to you is an exact copy of the database I'm using. If the ExecuteNonQuery worked against the database in the attachment, the SP should be in the database I'm using as well. Also, I can see the SP in the database. Everything executes correctly on Windows 7, .NET 4.0, WS 2003, and VS2010. I'm going to look into the Windows firewall. That may be the cause of the problem, though it does not make sense that the firewall would block on the http://ADO.NET provider and not communication with IBExpert, RazorSQL, etc... Will post my findings. |
Commented by: Cecil Martin (rabbitdogs) I have un-installed and re-installed Firebird-2.5.2.26540_0_x64 and get the same results when trying to execute. Stopping the Windows firewall gets same results when trying to execute. Attached file is a screen capture showing the SP does indeed exist in DB. I'm open to trying any suggestion you may have. |
Modified by: Cecil Martin (rabbitdogs)Attachment: SP_JOBQ_ADD.PNG [ 12366 ] |
Commented by: Cecil Martin (rabbitdogs) Executing SP from IBExpert works as expected. The only errors encountered are through http://ADO.NET provider. |
Modified by: Cecil Martin (rabbitdogs)priority: Critical [ 2 ] => Blocker [ 1 ] |
Commented by: Cecil Martin (rabbitdogs) Problem resolved. Typographical error. Sorry for the hassle. Please close. |
Submitted by: Cecil Martin (rabbitdogs)
Attachments:
SP_ERROR.zip
SP_JOBQ_ADD.PNG
When executing a stored procedure, the provider returns an error stating the stored procedure doesn't exist. Error occurs when trying to execute command as type StoredProcedure or Text. Following are stack trace messages:
Using fbcommandbuilder.deriveparameters to derive parameters for stored procedure:
Error:
Stored procedure doesn't exist.
Stack Trace:
at FirebirdSql.Data.FirebirdClient.FbCommandBuilder.DeriveParameters(FbCommand command) in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommandBuilder.cs:line 71
at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime execTime, String theUser, Int32 JobId, Int32 JobsId) in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 376
at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line 44
And for executing as "execute procedure sp_jobq_add(?,?,?,?,?,?)":
Error:
Dynamic SQL Error
SQL error code = -204
Procedure unknown
SP_JOBQ_ADD
Stack Trace:
at FirebirdSql.Data.FirebirdClient.FbCommand.ExecuteNonQuery() in c:\Users\Jiri\Documents\devel\NETProvider\working\NETProvider\source\FirebirdSql\Data\FirebirdClient\FbCommand.cs:line 520
at JCatsData.DbStore.AddJobToQueue(String cmd, DateTime execDate, DateTime execTime, String theUser, Int32 JobId, Int32 JobsId) in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\JOCE\JoceEnt.JCATS\JcatsApi\DbStore.vb:line 396
at SalesRepAgingInvEOM.Module1.Main() in C:\Users\cmartin\Documents\Visual Studio 2012\Projects\ConsoleApps\SalesRepAgingInvEOM\SalesRepAgingInvEOM\Module1.vb:line 44
The text was updated successfully, but these errors were encountered: