Skip to Content
Former Member
Apr 29, 2009 at 02:23 PM

Set datasource location without being able to log into to server?


Hi, I have a problem with promoting my reports to a production environment.

Crystal 10, Oracle 9, connecting via RDO (Oracle ODBC Driver 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.

Any ideas?

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?