AnsweredAssumed Answered

Pi ODBC connection string for Microsoft Access

Question asked by jlamantia1 on Mar 8, 2018
Latest reply on Mar 9, 2018 by gmichaud-verreault

Hello,

 

I'm trying to get a connection to my PI Data Server using the PI ODBC Driver through MS Access. I'm using a pass-through style query and have been trying many variations of this string in the ODBC Connect Str box: "ODBC;Driver={PI ODBC Driver};Server=<myservername>;Trusted_connection=Yes;Provider_Type=PIOLEDB;Provider_String={Data Source=<myservername>;Integrated Security=SSPI;};". Unfortunately the most progress I've made was getting the driver to ask me to confirm logging in before returning a pretty unhelpful error:

 

MSAccessPIODBCuninformative.PNG

I've been refering to the 2016 User Manual's instruction for connection strings but I'm not sure what I'm doing wrong here. Any ideas where I should start would be greatly appreciated.

 

Thanks,

Joe

 

Edit: Additionally, here is the test query I'm trying to run: "select * from [piarchive]..[pisnapshot];".

 

Edit 2: I should point out that I have been (mostly) successful with bringing in data to Access through a DSN connection using the PI ODBC driver, but this is not the approach we are looking to take.

Outcomes