Hi!

Something is wrong with SHAPED recordsets retrieved from SQL Server 2005.
I have a disconnected hierarchical recordset.
I can assign values to the MAIN or TOP level of the recordset, but I am
not allowed to add or changes field values of the subrecordsets.

The code runs good when I connect to a SQL Server 2000.
But connecting to a SQL Server 2005 produces an error in the client as soon
as I try to assign values to fields in the subrecordsets:
-2147217887
Multiple-step operation generated errors. Check each status value.

Here is my connnectionstring:
Provider=MSDataShape.1;Data Source=myserver;Data Provider=SQLOLEDB.1;Initial
Catalog=myDB;Trusted_Connection=yes;

Can someone help me out, please? I've got to get the application working on
the new database server of a customer.

Andreas

OBJECTPROPERTY problem
T-SQL: How to loop through the resultset from another procedure?
Count Occurances in a column
Who has the highest bid?
optimize queries with unexpected results