How to change datasource in CR XI Server

[Former Member]

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 · Accepted solution]

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.