I have a VB6 application running in Wins Server 2008 Enterprise (x86), DB server is MS SQL 2005, getting Error:
-2147467259 Rowset cannot be loaded because the stream is invalid.
error at a ADO.Recordset calling .RecordCount and .Sort
This only happen to 1 of the data query (it is a Stored procedure, but only 1 SP have this error, other part of the application calling query other data no issue). This error only happen to 2 DB (in the DB Server we have 5 same DB apply to 5 clients, only 2 client have this error for the same function same application running in the same machine, which the application itself can choose to query from any of the DB for the same function).
install the same application into a Wins Server 2000, connecting to the same DB server (same DB), no error for all the DB. This error only happen in Wins Server 2008.
Anyone face this problem before? any solution for this?