| calling reports from forms [message #458890] |
Wed, 02 June 2010 06:51  |
mahajneh
Messages: 16
Registered: May 2010
|
Junior Member |
|
|
hello everybody
I need your help
my problem is :
1-I have a web application server called ( office_server).
2-Oracle 10g developer and report server(repserver10g) are installed on it.
3-I have different database servers:
a) "main_server" hava a database called main b) "sec_server" have a database called sec
so i have 3 servers 1st have the report server and the others have the databases>
when i call a report which reads data from main_server
i use the report server(repserver10g) and it works fine
I connect as user/pass@main
but when i developed an application that reads data from sec_serevr and use(repserver10g) to run reports does not work
I connect as user/pass@sec
any ideas or suggestions please
|
|
|
|
| Re: calling reports from forms [message #463764 is a reply to message #458890] |
Sat, 03 July 2010 04:09  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Sorry that I have been so long in replying. Have you solved your problem?
Verify that 'sec_server' is defined in the 'tnsnames.ora' file used by 'repserver10g'.
Basically, look at all the 'tnsnames.ora' files you have on your servers.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
