IanWaterman
Programmer
Hi
CR8.5 on SQL server 2005 using Active Data (ADO) to stored procedures.
Reports all run fine through application when called by ASP.
However, when I need to fix/amend I can not always get them to run via Crystal.
The stored procedure executes on both my live and UAT servers, and are identical as I have copied from Live to UAT just to be sure. I have also made sure that in SP I have
set NOCOUNT ON
To make sure only the required dataset is returned.
When I run the report via Crystal pointing at Live it works fine, however, when I repoint at the UAT server I get the error
Microsoft OLE DB provider for SQL Server:
Multiple step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
In the past set NOCOUNT ON, overcame this problem. Is there something else I may have missed which is OK on Live but not done on UAT. The DBA has no idea what could be causing this.
Thanks in advance for your help.
Ian
CR8.5 on SQL server 2005 using Active Data (ADO) to stored procedures.
Reports all run fine through application when called by ASP.
However, when I need to fix/amend I can not always get them to run via Crystal.
The stored procedure executes on both my live and UAT servers, and are identical as I have copied from Live to UAT just to be sure. I have also made sure that in SP I have
set NOCOUNT ON
To make sure only the required dataset is returned.
When I run the report via Crystal pointing at Live it works fine, however, when I repoint at the UAT server I get the error
Microsoft OLE DB provider for SQL Server:
Multiple step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
In the past set NOCOUNT ON, overcame this problem. Is there something else I may have missed which is OK on Live but not done on UAT. The DBA has no idea what could be causing this.
Thanks in advance for your help.
Ian