DATASOURCE LOCATION SETTTINGS IN CRXI

[khan007]

Hello

I am using CRXI Designer.
I have a question related to DataSource Location settings.

Till last month we were in an environment where we had two different test and production database servers with same database nameshaving same structure but different data.

1) TEST_SERVER Database: masterdb
2) PROD_SERVER Database: masterdb

I had one ODBC DSN as ReportsDSN which i used to pointing any one as needed.

Now we have created ONE database server and has two different databases with different names.

1) NEW_SERVER Database: Testdb
2) NEW_SERVER Database: Proddb

I still have a same ODBC DSN as ReportsDSN but it's not working with CRXI report designer.

It's work fine when i use CR 8.5 Designer and switch databases on my DSN.

BUT I am unbale to retrive any data in CRXI designer when set/switch my DSN to Testdb from Proddb.

Initially I set my DSN "ReportsDSN " to Testdb and created a New connection by using ODBC (RDO) and select Testdb. Worked fine.

Later when i want to run against PROD database ,made changes in DSN "ReportsDSN "setting and pointed to Proddb.

Now when i open my report, it was still showing database as
Testdb and had only one connection pointing to Testdb.

So i thought and created another connection and pointed to
Proddb.

Now i have two connections pointed to diffferent database, but never work.

Please advice