-
1
- #1
Just found solution for a nagging probllm, hopefully it may be useful for someone.
Problem:
While openig Oracle Reports files by double clicking, some files open fine, while others display the error:
REP-0501 Unable to connect to specified database
ORA-12203 TNS unable to connect to destination
Then the login window displays with the file name in the User Name window.
Reason/Solution:
This happens if there are space characters in the full path name to the file. Report Designer for Windows does not recognize correctly path names valid for Windows. For example, if a reports is on the path
it won't load to Report Designer with double click.
Problem:
While openig Oracle Reports files by double clicking, some files open fine, while others display the error:
REP-0501 Unable to connect to specified database
ORA-12203 TNS unable to connect to destination
Then the login window displays with the file name in the User Name window.
Reason/Solution:
This happens if there are space characters in the full path name to the file. Report Designer for Windows does not recognize correctly path names valid for Windows. For example, if a reports is on the path
Code:
C:\Desktop\My Documents\report.rdf