SQl Server Stored Proc

[itgowrishankar]

Hi,

I have an strange issue with SQL Server Store proc in Cogno 10.2.2.

I come across to use a stored proc which will results some data to display on the report.

My issue is I am able to run the reports with the stored proc in Dev and QA environments. But, the same reports are failing in UAT.
I have confirmed that the access permission in Dev, QA and UAT are same from SQL Server end. And, I am using Data Query type for Store Proc in Framework Manager.
The stored proc looks like as the attachement (not actual stored proc)

I am brain storing to fix this issue as the reports are running in Dev and QA and sameone is failing in UAt.

Any inputs are really appreciated. Thanks.

[itgowrishankar]

Hi,

I figured out the issue.

The issue is with the Datasource connection provider. In Dev, the datasource connection has created using Microsoft SQL Server (OLE DB) provider where as in QA and PROD datasource connection has created using Microsoft SQL Server (Native Client).


This may help to you if come across with similar issue.