Connection messages and errors

This topic contains common connection messages, including messages that indicate connection problems and the corresponding error messages.

These messages are visible as output of the iPiSql.ps1 ODBC sample application.

Other applications might display messages in a message box or log file, depending on how those applications handle exceptions.

Successful connection

Connected to the PI SQL Data Access Server version 01.05.0008.16125.

Product Status

------- ------

PI Integrator Framework Ready

Incorrect user name or password for connection to PI SQL DAS

[PI SQL DAS gSOAP Channel] HTTP Error
Details: HTTP/1.1 403 Forbidden

Incorrect PI SQL DAS

ERROR [08004] [PIODBC]
System.ServiceModel.EndpointNotFoundException: Could not connect
to net.tcp://myPIServer:5462/DataAccessServer/Query. The
connection attempt lasted for a time span of 00:00:01.0156518. TCP
error code 10061: No connection could be made because the target
machine actively refused it 192.168.0.10:5462.

or

ERROR [08004] [PIODBC] [PI SQL DAS gSOAP Channel] No connection
could be made because the target machine actively refused it.
Details: connect failed in tcp_connect()

Note: This error message also occurs when the PI SQL DAS port is linked by rules, such as those implemented by McAfee software (port 5461 or 5462 blocked by access rule).

Firewall does not allow inbound connection on PI SQL DAS side

[PI SQL DAS gSOAP Channel] A connection attempt failed because the
connected party did not properly respond after a period of time,
or established connection failed because connected host has failed
to respond.

SSL not configured (error appears after short timeout)

[PI SQL DAS gSOAP Channel] EOF was observed that violates
the protocol. The client probably provided invalid authentication
information.
Details: SSL connect failed in tcp_connect()

Certificate not suitable error (appears immediately)

[PI SQL DAS gSOAP Channel] EOF was observed that violates the
protocol. The client probably provided invalid authentication
information.
Details: SSL connect failed in tcp_connect()

SSL Certificate binding error (appears immediately)

[PI SQL DAS gSOAP Channel] Error observed by underlying BIO:
Connection reset by peer
Details: SSL connect failed in tcp_connect()

The SSL certificate binding error above usually corresponds to an error in the PiSqlDasAutoConfig.log file. You may be able to fix the problem by running the configuration tool, PiSqlDasAutoConfig.exe from an administrative account with elevated privileges.

1. Remove the existing configuration by executing the following file from a command prompt: PiSqlDasAutoConfig.exe -r

2. Generate a new configuration by executing the command again: PiSqlDasAutoConfig.exe

See Configure PI SQL DAS if you require the use of enterprise certificates.