Solved

Failed to open a rowset (ASP.NET/VB.NET)

Posted on 2004-09-28
13
6,024 Views
Last Modified: 2007-12-19
I have the following setup:

I am building an Web app (ASP.NET) on my Desktop, and porting a copy of the app to a laptop (to demonstrate to the customer)
The app is a front-end to a SQL Server 2000 backend, and the IDENTICAL databases exist on both the Desktop and the Laptop.  I have built several reports using CR.NET and they run PERFECTLY on the Desktop, however, with EXACTLY the same setup on the Laptop, the reports are INVARIABLY raising the "Failed to open rowest" error.

There is NO rao filtering, and the Reports are basied on  VIEWs in the database, which do in fact return data.

Any Ideas?  Where shuold I start looking?

AW
0
Comment
Question by:Arthur_Wood
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 3
  • 2
  • +1
13 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 12170139
This is generally a missing dll problem.  Did you simply move the app to the laptop or did you install it?

Here is a list of the required dlls for CR9
http://support.businessobjects.com/library/kbase/articles/c2012421.asp


Merge modules for CR.Net 2003
http://support.businessobjects.com/communityCS/FilesAndUpdates/cr_net_2003_mergemodules_en.zip.asp

mlmcc
0
 
LVL 44

Author Comment

by:Arthur_Wood
ID: 12170492
I have FULL VS.NET 2003 installed in both places, with ALL the options.  I can freely edit the CR .rpt file(s) on the laptop.

I am reasonably sure that this is not a matter of a missing DLL.

AW
0
 
LVL 42

Expert Comment

by:frodoman
ID: 12172834
AW,

Are SQL Server instance name the same and in the same physical location?

When you say "identical" database does that include the data itself (because an error in your data - usually a null conversion can trigger this error message)?

frodoman
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 44

Author Comment

by:Arthur_Wood
ID: 12172873
Yes, the data is IDENTICAL...I did a full backup of the Database from the Desktop, copied it to a CD, then restored that copy onto the Laptop - separate full instances of SQL server on each box - obviously therefore different physical locations.  No, the instance names are not the same, but the rest of the application on the laptop works EXACTLY as it does on the Desktop, so the Instance names are not the issue, it only the CR reports that have the problem

The data in both cases are record for record IDENTICAL, in all the tables.

AW
0
 
LVL 10

Expert Comment

by:ebolek
ID: 12173327
How do you connect to the database from laptop. Do you use OLEDB, ODBC. The file DSN names are the same. I would check the connection first. Try to login from the laptop witht he username and password that reprot uses to the database.

Regards
Emre
0
 
LVL 44

Author Comment

by:Arthur_Wood
ID: 12174957
The database is installed on the Laptop - I have a compete SQL Server instance on the laptop - works fine.  I am using ADO.NET and the SQLData client objects in .NET.

I can use the entire app (ASP.NET) except for generating reports.  And the reports, when opened in design mode in VS.NET can connect to the database, so that I can browse the data in the fields that make up the report.

I am using Rocky Lhotka's CSLA (Componert Scalable Logical Architecture - Visual Basic.NET Business Objects) for all of the app, except for the Reports (which are using ADO/OLEDB), and when the report designer is open, the reports can see the database, otherwise I couldn't have created the report design in the first place. - Go figure.

AW
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12176880
Are both instances of Crystal identical?  Are both instances of Visual Studio identical?
  Service Packs, etc

Can you compile the app on the laptop?  Will it work?

mlmcc
0
 
LVL 44

Author Comment

by:Arthur_Wood
ID: 12178601
Yes. Both are from VS.NET 2003, installed from the same Install CD.  Yes, I compile the app on BOTH the laptop and the Desktop, and both apps work with the single exceptoin that when I try to view the reports on the laptop, I get the 'failed to open rowest ' error.  Everything else about the app (ASP.NET) on the laptop works flawlessly.

as the King in 'he King and I (Yul Brynner)' said "tis a puzzlement"

AW
0
 
LVL 10

Expert Comment

by:ebolek
ID: 12179173
I used to get that error when a fiedl in the stored proc was deleted. The report looks for the field that he is using and gives that error message, Make sure that all fiedls are returned to the report
0
 
LVL 44

Author Comment

by:Arthur_Wood
ID: 12179272
The fields are IDENTICALLY the same on both platforms.  No changes have been made.

AW
0
 
LVL 44

Accepted Solution

by:
Arthur_Wood earned 0 total points
ID: 12182977
Problem has been solved - turns out to be a PERMISSIONS problem on the Views involved in creating the reports.  Oncve the ASPNET user was granted persmision on the Views, everything is fine.

Thanks for the help anyway.

I will be asking CS to delete this question, as I solved it myself.

AW
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 12185622
Rather than delete this ask them to PAQ it so others can learn from it.

mlmcc
0

Featured Post

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question