Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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 Member
Not what you were looking for? View more on this topic or Ask a question