Advertisement

06.25.2008 at 06:16PM PDT, ID: 23516732 | Points: 500
[x]
Attachment Details

Connection error---Cannot create a connection to data source 'xxxxx'. (rsErrorOpeningConnection)

Asked by deNZity in SQL Server 2005

Tags: microsoft, reporting services 2005

We have reporting services installed on the same server as our sqlserver2005 databases we also have oracle databases on another server.

clients used to be able to access their reports either oracle or sqlserver based from the browser using rs this week they can only access the sqlserver reports. For all oracle reports they get the following msg.

Cannot create a connection to data source 'xxxx'. (rsErrorOpeningConnection)

Nothing has changed on our server or network that we are aware of, no updates or hotfixes.Start Free Trial
[+][-]06.25.2008 at 06:19PM PDT, ID: 21871108

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.26.2008 at 12:39PM PDT, ID: 21878262

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628