Cannot create a connection to data source

[dbsql]

Hi all,

I am trying to view report that i deployed to reporting service but when i try to view it, it gives error:

An error has occurred during report processing.
Cannot create a connection to data source 'INVC'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors

the datasource is ODBC for Oracle!!!

 

[xlbo]

sounds like a permissions error. The issue is not that it doesn't know what the data source is - the issue is that it cannot connect to the data using the credentials that you have supplied....

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question