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 |
|
josh2abhi
Starting Member
2 Posts |
 Posted - 2011-04-19 : 04:11:57
|
| a. When using Excel 2007 as data base for SSRS report I am able to generate and run SSRS report properly on Microsoft Visual Studio (on my pc)b. But when I deploy the report and data source on SSRS report server it asks for DSN name (here I get stuck)i. If I give full dsn path it says DSN name too long (dsn also on server in same folder)ii. Doesn't recognize the file if no address is given (even though dsn and datasource file are in same folder on report server)iii. If I remove DSN it says “Cant find datasource name and default driver not specified” (without DSN in connection string it is working fine on my PC) |
|
|
ajthepoolman
Constraint Violating Yak Guru
384 Posts |
Posted - 2011-04-19 : 09:13:02
|
| This is a huge guess on my part, but if the file works on your machine and doesn't work on the server then I would assume that Office is not installed on the server? Again, complete guess on my part. I would assume that it isn't enough to put the file on the server but that the Office suite would have to be installed too.Hey, it compiles. |
 |
|
|
josh2abhi
Starting Member
2 Posts |
Posted - 2011-04-21 : 04:13:32
|
| MS Office Suite is installed on the server but still no success :( |
|
|
|
|
|
|
Missing DSN in datasource SSRS on report server