Hi, I have a problem with promoting my reports to a production environment.
Crystal 10, Oracle 9, connecting via RDO (Oracle ODBC Driver 188.8.131.52.0). I have reports connecting to a QA environment, with DSN named QA. I would like to re-point them to the production database, using a DSN called PROD. Should be simple - make a DSN called PROD, check it connects and Set Datasource Location in Crystal.
But as a humble developer, I have no login for the PROD server. I can't complete the Set Datasource Location action without a successful login. So I'm stuck.
I have thought of making a DSN called PROD that uses the QA connection details, and then hoping that when the report gets to the PROD server, it will just find the PROD DSN and use the connection info stored within it. Would that work?