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

[Former Member]

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

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

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?

Thanks,

Bill.

[Former Member]

HI,

How come you dont know the Login? are you authorized? it is very difficult to get information in your end,

Regards,

Clint

[Former Member]

The report is for a third party n-tier application. Reports connect to the database via ODBC; users through a middle tier. I have a user account for the production application, but not a database login - and I am not going to be allowed one due to corporate rules.

What I'd really like to be able to do is tell Crystal that the DSN name has changed, and for it to accept this without needing to login and verify - it's trying to be too helpful.

Is this possible?

Thanks,

Bill.

[Former Member]

Hi,

It is not possible, you cant access the database without knowing the database login its part of the database security not to be hacked or manipulated. All database server are all a like

Regards,

Clint

[Former Member]

Thanks - I'd feared this was the case but it's good to know the truth.

Bill.