April 18, 2011 at 11:12 pm
Hi All,
Need some help.
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)
Thanks in Advance!
April 19, 2011 at 10:10 am
Modify a report and check the DSN path is the same as you deploy on the SSRS
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
April 19, 2011 at 11:27 pm
DSN path i give is correct but it says DSN File name too long
Connection string as follows:
"
DSN= \\****.*****.*****.com@SSL\sites\*****\Data Connections for PerformancePoint;DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);driverid=1046;dbq=\\****.*****.*****.com@SSL\sites\*****\Deliverables_ww09_11.xls;defaultdir=\\****.*****.*****.com@SSL\sites\*****"
This gives error DSN Name too long.
If i give following connection string with out DSN
"
DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb);driverid=1046;dbq=\\****.*****.*****.com@SSL\sites\*****\Deliverables_ww09_11.xls;defaultdir=\\****.*****.*****.com@SSL\sites\*****"
It gives error: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Please help
April 19, 2011 at 11:28 pm
I am using ODBC Connection to connect to an excel file database on Report Server.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply