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 OLEDB 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:

Exception calling "Open" with "0" argument(s): "Bad protocol order"

Invalid data source

The following error message occurs if the specified data source does not exist, is not listed, or if the spelling is wrong:

Exception calling "Open" with "0" argument(s): "Invalid data source"

No data source specified

The following error message occurs if the required data source was not specified:

Exception calling "Open" with "0" argument(s): "No data source specified"

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:

Exception calling "Open" with "0" argument(s): "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:

Exception calling "Open" with "0" argument(s): "None of the protocols could be used to establish a
connection using Windows Integrated Security"