From:	Vollie Sanders	Date:	Mon Sep 15 12:22:37 2008
Subject:	Cryptic error from PB11.2 MS SQL OLEDB connection Question

we are upgrading several apps from PB10.3 to 11.2
while testing the PB11.2 version of an app
we encountered an error msg from the database
that said the following-
DataWindow Error
! Select Error: Requested result set number 1 not found.

when we went back to the PB10.3 version and ran it,
we got the following msg-
DataWindow Error
! Select Error: SQLSTATE = 42000
Microsoft OLE DB Provider for SQL Server
Could not find stored procedure 'sp_sel_quote_detail_lbr_qty_01'.

investigating we found that one of the developers had tried to
modify this stored proc and it did not reload and they missed it.

thats fine, we fixed it. my question is why the cryptic message from
PB11.2 using the new OLEDB connection? even tried the new Native
and it gave the same cryptic message. why it did not supply the name of
the SP like previous OLEDB?