Failed to open a rowset (ASP.NET/VB.NET)
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
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
ASKER
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
I am reasonably sure that this is not a matter of a missing DLL.
AW
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
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
ASKER
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
The data in both cases are record for record IDENTICAL, in all the tables.
AW
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
Regards
Emre
ASKER
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
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
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
Service Packs, etc
Can you compile the app on the laptop? Will it work?
mlmcc
ASKER
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
as the King in 'he King and I (Yul Brynner)' said "tis a puzzlement"
AW
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
ASKER
The fields are IDENTICALLY the same on both platforms. No changes have been made.
AW
AW
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Rather than delete this ask them to PAQ it so others can learn from it.
mlmcc
mlmcc
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