How to set up ODBC connection to SQL DAS?

Hello Olav​ ,

I believe that you are trying to connect PI ODBC Driver (indicated by "PI OLEDB Provider" Type) against PI SQL Data Access Server (RTQP Engine) (indicated by Net.Tcp via port 5465). This will not work because these products are 2 different PI SQL generations.

If you like to stick with PI ODBC Driver, you need to install PI SQL Data Access Server (OLE DB) as the server component.

If you like to stick with PI SQL Data Access Server (RTQP Engine) which is what I would recommend based on the information shared, please use PI SQL Client (ODBC).

Thanks, great info. Now I see why the ODBC driver comes up with default ports 5461 and 5462. I have the 2016 ODBC driver installed, but the SQL DAS RTQP Engine installed.

The SQL DAS engine was not properly installed though, so I have to re-install it. However, I can't find the old install package, so I will have to upgrade the PI server and PI AF server first. I don't want to use the legacy ODBC driver. Thanks again.

Thanks, great info. Now I see why the ODBC driver comes up with default ports 5461 and 5462. I have the 2016 ODBC driver installed, but the SQL DAS RTQP Engine installed.

The SQL DAS engine was not properly installed though, so I have to re-install it. However, I can't find the old install package, so I will have to upgrade the PI server and PI AF server first. I don't want to use the legacy ODBC driver. Thanks again.