How can I define the Oracle data source flexible so that I can change?

[Former Member]

Dear all:

I have a problem in define the crystal report file(.rpt) in Crystal report desinger 9 by using Oracle database.

Since in the "Control Pancel" -> "ODBC" ->, I can't find the oracle DNS definition in order to define the ORACLE database's IP address, port etc. So I can't allocate the Datasource in "Data base" -> "Define Data source" of Crystal report 9 desinger. Finally, I have to explicitly define the Data source by browsing the Oracle DB in "Define Data source" function. It is not flexible while I want to switch the DB server by change its IP adress.

But in contrast, I can easily define a MS SQL server DNS and allocate it to .rpt file.

Is that something I was wrong? Any reference or answer are appriciated!

[former_member11696]

Hello,

Moved to Crystal Reports Database forum.

CR needs an Oracle Client installed. Once it is installed then you'll find a driver to create a DSN and then you can set location to another Oracle Server.

You have to first install the Oracle Client.

It's also better to create your reports off of Oracle, it's easier to then set location to MS SQL Server.

Thank you

Don