Connection messages and errors

Common connection messages, including error messages that indicate connection problems, are provided here.

The messages are visible in Windows PowerShell as output of the iPiSql.ps1 sample application. Different PI SQL Client ODBC applications might display below messages in a message box or log file, depending on how those applications handle exceptions.

Successful connection

The following message occurs when a successful connection is established:

Connected to PI SQL Data Access Server (RTQP Engine) 2018 SP3 Patch 3, 1.8.21196.1
Driver name: PI SQL Client, version: 4.2.22020.1.

Item: AF SDK Version: 2.10.9.593 FriendlyVersion: 2018 SP3 Patch 3
Item: AF Server Version: 2.10.9.593 FriendlyVersion: 2018 SP3 Patch 3
Item: Master Catalog Version: 2 FriendlyVersion: null
Item: Model Schema Version: 3 FriendlyVersion: null
Item: Operating System Version: 6.2.9200.0 FriendlyVersion: Microsoft Windows 10 Enterprise
Item: Query Processor Version: 1.8.21196.1 FriendlyVersion: 2018 SP3 Patch 3
Item: SQL Server Version: 15.0.2080.9 FriendlyVersion: Microsoft SQL Server 2019 (RTM-GDR) (KB4583458) - 15.0.2080.9 (X64)

Bad protocol order

The following error message occurs if the specified protocol does not exist or if the spelling is wrong:

ERROR [HY000] [PI SQL Client] Bad protocol order.

No AF Server specified or misspelled

The following error message occurs if the AF Server was not specified or if it was misspelled:

ERROR [01S00] [PI SQL Client] The specified AF Server is invalid.

None of the protocols could be used to establish a connection using the provided user name and password

The following error message occurs if the specified User ID, or Password, or both do not exist, or if the spelling is wrong:

ERROR [08001] None of the protocols could be used to establish a connection using the provided user name and password.

None of the protocols could be used to establish a connection using Windows Integrated Security

The following error message occurs if Windows Integrated Security is not available for the specified data source:

ERROR [08001] None of the protocols could be used to establish a connection using Windows Integrated Security.