Came accross some great news from Stuart Carnie, the developer behind the SalesLogix provider, and just had to share it.

If you have worked with recordsets in 6.2, then you will have probably seen this error.  “Multiple-step operation has failed.  Please check the status
of each value”  – or similar.  Quite useful, really.

However, in our quest to make things even more useful, we have improved this (a little).

It now actually reports the underlying message, such as “Cannot insert duplicate key row in object ‘ADHOCGROUP’ with unique index ‘XPKADHOCGROUP'” or “Cannot insert the value NULL into column ‘SECCODEID’, table ‘saleslogix_eval62sp1.sysdba.ACCOUNT’; column does not allow nulls.  INSERT fails.”

This was caused by a bug in the MSSQL Ole Db Provider, which cleared the global error list in MDAC, so the messages were not propagating back to the client.

Also, a new stored proc has been added, ‘slx_setpassword [oldpassword], [newpassword]’

This allows you to change the SalesLogix user password for the current connection.  You must specify the old and new passwords, or the operation
will report an error and no rows will be updated.