I am getting below error when I tried to access PI Db using PIOLEDB. What is the workaround to resolve this issue?
Error: PIOLEDB.1' provider is not registered on the local machine
The error simply means that the system cannot load PI OLEDB on the machine. It doesn't give us a clear idea what is causing this.
These questions should give us a better idea of your situation and ensure that you are using the correct PI OLEDB as well as to verify if the issue is caused by user privilege.
I get the same error when I connect from my laptop but I'm able to connect when I open Pi SQL Commander on the PI server. I have piAdmins and system administrator access on the PI server I'm connecting to.
I'm wondering if the user needs admin access on the box where he/she is running PI SQL Commander to avoid this error.
Just for confirmation, did you install PI OLEDB Provider on your laptop?
I have the PI OLEDB Enterprise 2012. My colleague also has this and he seems to have no issues accessing PI tables using SQL Commander.
You could try installing it according to this thread Error message: "The PIOLEDB provider is not registered on the local machine" . The link in Gregor's post might be outdated so here is the new link.
Retrieving data ...