Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2007-04-27 : 11:48:50
|
| 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 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 12:55:45
|
| Try test the connection in odbc. By the way, you have sql server on same machine with RS? |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2007-04-27 : 13:32:11
|
| yes. Do i need Oracle client to connect to db because I am trying to use alias and that's all i have access to right now!! |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-27 : 16:58:20
|
| Does dsn 'INVC' point to Oracle? Is it on RS machine? |
|
|
|
|
|
|
Cannot create a connection to data source