Calling ADO Stored Procedure from FB script

FinalBuilder Discussion
1

Hi,

We are using FB 6 (V6.3.0.1506). We use various SP that are defined in our db (SQL 2008). We started to experience following issues:

- sometimes the action 'ADO Execute Stored Procedure' failed with error:

Error : Parameter '@ResourceId' not found

When '@ResourceId' parameter is found and defined in SQL side. Other runnings of the same script with same project with same SP is successfull. This error occurs several times in 400-500 executions.

Please assist,

Rita

2

You will need to provide us with more information, such as the SP definition (does it return a recordset?), SQL Server version and service pack level, client side driver versions, connection string etc.

I had a look through our code and the error message is not generated on our side, it is caused by the ADO driver throwing the exception.

3

HI,
The SQL Server version is 10.0.2531 SP1.
The SP definition is :
ALTER PROCEDURE [dbo].[spDeallocateResource]
@ResourceId int ,
@RunBuildId bigint
AS
BEGIN
DECLARE @lockRes INT
DECLARE @Resource nvarchar(255)
…
END

It doesn’t return recordset.
How can I obtain the client side driver version?

Thanks

4
HI,
The SQL Server version is 10.0.2531 SP1.
The SP definition is :
ALTER PROCEDURE [dbo].[spDeallocateResource]
@ResourceId int ,
@RunBuildId bigint
AS
BEGIN
DECLARE @lockRes INT
DECLARE @Resource nvarchar(255)
......
END

It doesn't return recordset.
How can I obtain the client side driver version?

Thanks