• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1036
  • Last Modified:

Failed to open rowset Relational database S00000C not the same as current server

Does anybody know a solution for the following:


After migrating to V5.3 os/400 the following error occurs:
Error:
Error Occurred Reading Records: Failed to open a rowset. Details: HY000:[IBM][iSeries Access ODBC Driver][DB2 UDB]SQL0114 - Relational database S654BB6C not the same as current server S654F1AB
Program: chrystal 9 profesional
Server: IBM iseries os V5.3

max
0
maximaal
Asked:
maximaal
  • 2
  • 2
1 Solution
 
SpykairCommented:
Have you verified the database ?

Spykair
0
 
maximaalAuthor Commented:
yep, databases are up to date.

If i create a new report chrystal does work. If i want the old report to work, i need to "set the datasource location" and link each table on the server to the table in the report.

Max
0
 
mlmccCommented:
You may need to open the reports in the designer and SET LOCATION under the database menu as you have been doing.  The report keeps the database information around so it must be changed since the database name has changed.  

Do the reports work after you change the location or do you need to do that each time?

mlmcc
0
 
maximaalAuthor Commented:
Yes they keep on working when you saved them, but we have around 100 report and it's a hell of a job to change them, is there a simple solution?
0
 
mlmccCommented:
There are some tools available that supposedly can change many reports at the same time.

Look at RPT Inspector

http://www.softwareforces.com/Product/ri/pro/3/rptinspector.htm

mlmcc
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now