Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RDF file not loading into Report Builder on Windows 1

Status
Not open for further replies.

nagornyi

MIS
Nov 19, 2003
882
US
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
Code:
C:\Desktop\My Documents\report.rdf
it won't load to Report Designer with double click.
 
hi nagornyi,
thanks for the tip.

I have always come through this problem because I sometimes use network drive with a " " blank space in name, and always did I have to copy/paste the source in local drive to modify

But here, it would have showed error message : REP-0157 : the value for <keyword> must be Yes or No.

Now, when I double click a .rdf from a network drive with no " ", it works fine

Cheers,
Vincent
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top