August 23, 2010 at 7:36 am
Hi, looking for some advice on SharePoint integration. I have some reports that I built using VS2008 and am able to successfully deploy to a SharePoint site on our Intranet. My report uses a shared datasource and I can also deploy the shared datasources to the SharePoint site. The problem comes when I try to view the reports on S/P. I keep getting an error,
An error occurred during client rendering.
An error has occurred during report processing.
Cannot create a connection to data source 'DataSourceXX.
For more information about this error navigate to the report server on the local server machine, or enable remote errors.
When I look on the server at the error logs, I just see an error that the path to the data, (it's an Access database) is an invalid path. I'm wondering about that message, because the Access db is stored on a network directory. Do I need to make sure that the server has the drive mapped correctly that my client does? Meaning, I have the "X" drive mapped to the database on my client machine, does the server need to have the "X" drive mapped to the same drive also? Also...I do have the "Overwrite" setting set to TRUE in the properties for the Datasource.
Or am I missing something here?
Any help is greatly appreciated....
thanks!
September 15, 2010 at 9:39 am
You are probably better using the UNC path (ie \\machinename\sharename) to your folder on the network that contains the access db rather than using mapped drives. Remember that mapped drives are linked to you user profile and therefore can be different between your client machine and the user account setup to run the reports on the server.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply