Print Page | Close Window

Failed to open rowset

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=671
Printed Date: 04 May 2024 at 11:21am


Topic: Failed to open rowset
Posted By: dave7310
Subject: Failed to open rowset
Date Posted: 16 May 2007 at 2:09am
I have a report created in crystal 11. using the pull method. The report used to work fine now i keep getting a messagebox error in the report viewer: Failed to open rowset. Has anyone come across this.
 
 


Replies:
Posted By: BrianBischof
Date Posted: 16 May 2007 at 8:48am
A lot of times people will find out that the security changed on them and their report no longer has access to the database. Have you checked security?

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

Posted By: martin
Date Posted: 23 May 2007 at 3:21am
Hi
 
I am having exactly the same problem using Version 9.
We have installed a new server running Server 2003 (previuosly 2000) with the same server name and now none of my Crystal Reports will run. The initial error message is "Failed to open a rowset."
 
I have checked security and I have full acces rights - any ideas?

Posted By: dave7310
Date Posted: 26 May 2007 at 6:30am

I thought exactly the same, then i found out that the role that held the permissions hadnt copied across. Double check everything. The only other thing to try is making sure you give rights to each of the tables/views if using the Pull method. this gives a function that will do that for all report tables and sub report tables http://aspalliance.com/490 - http://aspalliance.com/490

Good luck :)


Print Page | Close Window