Data Connectivity
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Data Connectivity
Message Icon Topic: Crystal Reports - Problems Post Reply Post New Topic
Author Message
varmabjr
Newbie
Newbie


Joined: 20 Jun 2007
Online Status: Offline
Posts: 1
Quote varmabjr Replybullet Topic: Crystal Reports - Problems
    Posted: 20 Jun 2007 at 2:29am

We had developed a web based application using .Net 2.0 (C#) , Crystal reports (bundled version within VS2005) on Window XP, SQL Server 2005, we are able to see all the reports on this development enviroment, but when the application is deployed on Windows 2003 server , IIS 6.0 and SQL server 2005 , we are not able to view the reports we are thrown with an error as

Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'sp_xxxx' expects parameter '@ppppp', which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File

Could you please explain what the problem is ? as we are stuck with this problem for the migration of application to the user community.

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 20 Jun 2007 at 10:03am
I'm not sure of this error message's meaning, but when people tell me they have problems moving reports from the dev box to production, 99% of the time the problem is due to permissions. Either you don't have permission to the folder with the reports or the report doesn't have all permissions to the SQL database. This is pretty much the reason for all these problems.

That said, it sounds like you might actually be hitting the database but the SP doesn't have the parameter that CR expects. Is the SP/view IDENTICAL to what's on the dev box? Even the smallest difference (data type, param name, order etc.) can throw CR off. You know how picky computers are - you really have to be careful to make sure everything is identical.

I hope that helps.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
JeremyDP
Newbie
Newbie
Avatar

Joined: 25 Jul 2007
Location: United States
Online Status: Offline
Posts: 2
Quote JeremyDP Replybullet Posted: 25 Jul 2007 at 10:02am
I am getting this same error, however it is not a result of moving from DEV to PROD.  The odd thing is that it works as expected in the VS2005 IDE when I select the Main Report Preview tab from the report in question.
 
When I run the application (Start Debugging) and select to preview the report I get this error:
 
Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'sp_xxxx' expects parameter '@ppppp', which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File
 
Any help would be much appreciated!
IP IP Logged
Shaft
Newbie
Newbie


Joined: 27 Jul 2007
Online Status: Offline
Posts: 2
Quote Shaft Replybullet Posted: 27 Jul 2007 at 5:23am
The error is because as it's says the stored procedure you are calling is expecting parameter @ppp which you are not supplying. How are you calling the data for the report?
IP IP Logged
ntdong
Newbie
Newbie


Joined: 02 Aug 2007
Online Status: Offline
Posts: 1
Quote ntdong Replybullet Posted: 02 Aug 2007 at 6:43am
I am getting this same error.
 
my code :
<
myReportDocument.SetParameterValue("@parameter", value)
SetDBLogonForReport(myConnectionInfo, myReportDocument )
>
 
When I change the DatabaseName to test DBLogon, I get this error :
 Failed to open a rowset. Details: ADO Error Code: 0x Source: Microsoft OLE DB Provider for SQL Server Description: Procedure or Function 'sp_test' expects parameter '@parameter', which was not supplied. SQL State: 42000 Native Error: Failed to open a rowset. Error in File
 
SetParameterValue doesn't work.
 
  


Edited by ntdong - 02 Aug 2007 at 6:44am
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.