When running a query that returns an ADO recordset of a certain size I receive an error:
-2147467259 Data provider or other service returned an E_FAIL status.
This problem only happens when these conditions are all met:
• The client is Vista
• The client is using the SQLOLEDB provider
• SSL (Force Encryption) is enabled on the SQL Server
• The data returned is of a certain size (changing the query or the data in the table by one byte will cause it to succeed)
If any of these conditions is changed, the query succeeds. It seems to be related to the size of the data that is received back from SQL Server since changing one character of the query will cause it to work.