I've been asked how does the PIOLEDB provider driver collect data from the PI system. More specifically what needs to be installed and where, to allow the link to work. If anyone can give me a quick heads up, that would be great. I;ve tried looking in the documentation but it doesn't show where the driver should be installed. As you may have guessed I'm not the familiar with OLEDB, so any help or recommendations are gladly received.
What's the difference between then ODBC and OLEDB drivers? Should I use one over the other? I'm told we are only going to access PI Data Archive information and not PI AF at the moment, but might want to access AF data later on.