Hello,
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."
+ CategoryInfo : NotSpecified: (:) [], MethodInvocationException
+ FullyQualifiedErrorId : DotNetMethodException
Following is the way I am trying to connect:
$conn = New-Object System.Data.OleDb.OleDbConnection("Provider=ASAProv.90;Data Source=SymantecEndpointSecurityDSN;User
Id=DBA;Password=*************");
$ds = New-Object "System.Data.DataSet" "SEMData"
$query = ***************
$da = New-Object System.Data.OleDb.OleDbDataAdapter($query,$conn);
#$dc = New-Object System.Data.OleDb.OleDbDataAdapter($count,$conn);
$conn.Open();
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.