469,272 Members | 1,560 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,272 developers. It's quick & easy.

rsErrorOpeningConnection with oracle

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
Jul 23 '05 #1
0 2917

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by susmita_ganguly | last post: by
38 posts views Thread by Mike | last post: by
13 posts views Thread by Chris Botha | last post: by
2 posts views Thread by Ruslan A Dautkhanov | last post: by
reply views Thread by Jack | last post: by
reply views Thread by Winder | last post: by
1 post views Thread by CARIGAR | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.