Solved

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

Posted on 2004-09-28
13
6,013 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
  • 6
  • 3
  • 2
  • +1
13 Comments
 
LVL 100

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
 
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
6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

 
LVL 100

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 100

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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video discusses moving either the default database or any database to a new volume.

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now