I have a question out there, PI OLEDB Enterprise Provider in SSRS , in regard to using the enterprise provider with SSRS. I do not have PI OLEDB Enterprise downloaded on the same machine as SSRS, but it is on my local. I am accessing SSRS through a server.
I am confused why the connection would work when using the connection properties, but not in the data source properties.
- Shouldn't both connection tests fail if the enterprise provider is not downloaded on the same machine as SSRS?
- If PI OLEDB Enterprise isn't downloaded on the same machines as SSRS, why is the option available in the drop-down for provider?
I'm more curious on why this behavior is happening.