Troubleshooting

To identify solutions when PI SQL Client ODBC does not connect or does not get data, OSIsoft recommends that you test components in the order they are used as described here:

1. Run PI SQL Data Access Server (RTQP Engine) interactively to see more information, debug output, or use the PI SQL DAS (RTQP Engine) Event Log to check for error messages.

2. For more information, see the PI SQL Data Access Server (RTQP Engine) Administrator Guide.

   Note: When PI SQL Data Access Server (RTQP Engine) is run interactively, Kerberos authentication cannot be used.

3. For PI SQL Client ODBC, enable logging for the driver.

4. Install PI SQL Client ODBC on the same computer as PI SQL Data Access Server (RTQP Engine).