Solved

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

Posted on 2004-09-28
13
6,017 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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 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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Reports Sum only working when drilling down 20 53
Help with a Crystal Report Formula 8 46
Crystal Reports Date Calculation 10 38
A string is required here error 20 19
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 …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 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