Hi! Hope you are well!
Typically, reports are generated on one of our dedicated web servers. My desktop application just makes a HTTP request, gets the pdf report, and all is well.
However, we have some stand-alone/offline clients who have a local database on their machine and we are trying to offer them the ability to run our reports. it seems they have everything they need.
I'm calling RWRun60 in my application to generate the reports for these clients. What I've found is that when I make my call to RWRun60 in my application it fails (command-line & error message below).
"~path_to_oracle_home~\Bin\RWRUN60.EXE" report="~path_to_reports~\RepSummary.rep"" userid=USER1/~user_password~@XE DESTYPE=FILE BATCH=YES DESFORMAT=PDF DESNAME="~temp_file_path~\~temp_file_name~.pdf" PARAMFORM=NO P_REPORT_ID=13094 ERRFILE="~temp_file_path~\rep_errors.log"
ERR REP-0501: Unable to connect to the specified database.
ORA-12222: TNS:no such protocol adapter
That's a pretty self explanatory error message. Or so I thought. The TNS Names file is perfect. Everything works ... establishing connections works fine! So what's wrong? ...
If I run RWRun60, using IDENTICAL arguments/parameters, BEFORE establishing a connection to the database in the application, the report runs A-Okay.
When I run RWRun60, using IDENTICAL arguments/parameters, AFTER establishing a connection to the database in the application, the report fails.
Any help would be very much appreciated! -- I'm just a little confused here. Wondering if I (or Oracle) am locking resources or something ...?