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 |
|
zolf
Starting Member
15 Posts |
 Posted - 2007-10-01 : 04:15:24
|
| hello there,i am trying to using SSRS with Excel. in the BI Design(Visual Studio) wehn i preview the report i can see the report.but when i deploy it on the localhost and try to view the report in there.i get this error.please helpAn error has occurred during report processing.Cannot create a connection to data source 'DataSource1'.ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection ERROR [01S00] [Microsoft][ODBC Microsoft Access Driver]Invalid connection string attribute Trusted_Connection |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-10-02 : 10:07:23
|
| Have you checked Report Server >> Report property that your data source exists on Report Manager?Refer to SQL 2005 Books On Line >>How to: Configure a Report-Specific Data Source (Report Manager) |
 |
|
|
|
|
|
help with reporting service using Excel