I am trying to stablish a shared data source to an Access database for my reporting services. Is this possible? I only see connection type Microsoft SQL Server as Connection Type.. OLEDB is not recognized. How can I achieve this?
Hi,
Create a system ODBC data source for your access db from Control Panel Administrative tools.
Create a shared ODBC data souce in RS and select the data source you just created in Control panel.
After that it is business as usual. You may have to finetune some quirks for deployment, the host server should have the ODBC data source as well. An idea would be to try to use an UNC when defining the ODBC datasource and post your access db in a share in some server. That would give more portability.
Philippe
No comments:
Post a Comment