Connection error while connecting to SEP 12 embedded Database using powershell
I am trying to pull a report connecting to embedded databases of several SEPMs. This worked fine with SEPM 11. The issue started once we upgraded to SEPM 12. I am able to to connect using odbc to all the embedded databases and run the query..no issues even after upgrading. The issue is when trying to connect using powershell script.
I am getting this error
Exception calling "Open" with "0" argument(s): "The 'ASAProv.90' provider is not registered on the local machine."
Do anyone has the same issue? I read a post with the same issue, but that is not helping.
If anyone can point me to the right direction, that would be helpful. Thanks in advance.