Hi ,
I’am having the following strange situation.
First let me explain the configuration:
Windows 2000 server with sql-server and running reportingservices.
HP9000 Unix server with oracle 9i database
I’ve installed oracle client client tools on the W2K server and
configured a
connection to the oracle database.
Tnsping to oracle database works fine.
On the W2K server there are lot of reports running. There is one
report that
gets his data from the oracle database.
On irregular times this report is not functioning. The following error
is
generated :
Reporting Services Error
----------------------------------------------------------------------
----------
An error has occurred during report processing. (rsProcessingAborted)
Get
Online Help
Cannot create a connection to data source ’urko’.
(rsErrorOpeningConnection)
Get Online Help
Error while trying to retrieve text for error ORA-12541
----------------------------------------------------------------------
----------
Microsoft Reporting Services
While a tnsping to the oracle Database is working
After several retries the report is function well.
I’ve found some information about changing the settings in internet
explorer to refresh the page by every visit, but this didn’t change a
thing.
The tnsnames.ora is ok. Link to oracle with other programs like TOAD,
ORacle sql, oracle enterprise manager and all oracle clienttools works
fine.
It’s just with reporting services that I’m having problems.
Nothing found on oracle metalink.
Thanks for any advice.
Kind regards.
Kamil
--
Posted using the http://www.dbforumz.com interface, at author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbforumz.com/General-Disc...ict239796.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=834238