1953686 - Getting a SQLSTATE=21000 error when running SQL using the OLEDB database driver

When connected to Microsoft SQL Server using the OLEDB database driver ,  and running the following sql:

select *, (select (value_2) from table2 where table2.value_1 = table1.value_1) from table1

PowerBuilder will return the following error:

Select Error:  SQLState=21000

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, < , , < =, > , > = or when the subquery is used as an expression

When connected to Microsoft SQL Server using SNC, a resultset will be returned.  No error is returned.

• Sybase PowerBuilder
• Microsoft SQL Server

SNC, OLEDB, MS SQL Server, blocking factor, block , KBA , BC-SYB-PB , PowerBuilder , How To