Error: -2147467259 Rowset cannot be loaded because the stream is invalid.


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?

If you enjoyed this post, subscribe for updates (it's free)

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. The supported tag styles are: <foo>, [foo].

More information about formatting options

Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.