web report CGI

[jonathanlee]

I am going to build web report using Microsoft IIS, report server60, oracle database.(CGI way, not Cartridge way)
CGI seems working ok.
Now I have an issue: when I am going to test report server by commond:
rwcli60 server=Rep60_LIYCPQ userid=cos/cos@cos_dev

The error message indicated report server not working properly, can not be contacted.

Wish someone could give a solution how to make all done.

Thanks in advance!

Jonathan Lee

 

[sem]

Check your tnsnames.ora file for the correct Rep60_LIYCPQ entry. Try also to verify that report server is running (via services or task manager)

 

[jonathanlee]

Thanks for your suggestion.
Yes, I found the Rep60_LIYCPQ entry in tnsnames.ora(c:\orant\net80\admin\)
"Rep60_LIYCPQ,Rep60_LIYCPQ.world=(ADDRESS=(PROTOCOL=tcp)(HOST=LIYCPQ)(PORT=1949))", which is correct and created by installation of developer 6i.
And reportservice(Rep60_LIYCPQ) is running indicated by services of control pannel in Windows NT.

They are ok, but I still have that problem: after use
rwcli60 server=Rep60_LIYCPQ userid=cos/cos@cos_dev

error message say "can not connect to reports server "Rep60_LIYCPQ".
Please help more! Thanks!

Jonathan Lee

 

[Guest_imported]

We had this problem. I was told it was to do with numbers and underscores in the reports server alias, the solution I'm suggesting here worked for us. Add another alias to your tnsnames.ora file that does not have any numbers or underscores
e.g.
RepServLIYCPQ,Rep60_LIYCPQ,Rep60_LIYCPQ.world=(ADDRESS=(PROTOCOL=tcp)(HOST=LIYCPQ)(PORT=1949))

You may need to restart the servers (can't remember if we did, sorry)

Then use the alias in the report server call
server=RepServLIYCPQ&userid=cos/cos@cos_dev