I developed my reports against a development database. The reports are "executed" by a C# program that provides database login credentials for ASE 15.7 database. When I went to install reports into production they failed with a "Failed to retrieve data from database" exception. The C# program provided the correct login credentials for the production server. So, I said, let me try to connect to the prod server in the designer. Using the "Database Expert" I created a new connection to the prod server. No problem. I use the "Set Database Location" dialog to switch the report source(s); main and sub-reports. I refresh the report and it says "Failed to retrieve data from database" then "Database Connector Error: "Attempt to location entry in sysdatabases for database 'test3' by name failed - no entry found under that name.... Its like it logged into the prod server, but tried to use the test server's database name. In the "Database Expert" the database name is correct. How do I diagnose this? Is there problem changing the database name?
Thanks,
John