Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to change datasource in CR XI Server

Hi,

How can I change the database and server in CR XI server?

For example, my reports is designed against the 'pub1' database and the 'server1' server. How can I change the database to 'pub2' and the server to 'server2' in CR XI server?

I understand within the CR XI Server, there is a place for me to change the datasource.

Under the Database tab in Process Tab, I selected "Use custom database logon information specified here" radio button, and database driver as "ODBC". I entered the server IP, the login and password.

I am using SQL 2000 Server.

I run the report and get Error Message: "Failed to open the connection. C:\Program Files\Business Objects\BusinessObjects Enterprise 11.5\Data\procSched\crystalreport.reportjobserver\~tmp142c5653066e200.rpt".

I do not understand why failed to open the connection.

Please advise.

Former Member
replied

You will need to create an ODBC DSN on Windows first and then use the ODBC DSN's name instead of the IP Address under CMC >> Objects >> YourReport >> Process >> Database page.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question