rserroropeningconnection with oracle

Last Post 13 Jul 2005 12:43 AM by goffin. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

13 Jul 2005 12:43 AM
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.

Acceptable Use Policy