OLE DB Fixes & Changes for 6.2 SP1 – Multiple Step Operation

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.


Ryan Farley

Ryan Farley is the Director of Development for Customer FX and creator of slxdeveloper.com. He's been blogging regularly about SalesLogix, now Infor CRM, since 2001 and believes in sharing with the community. His new passion for CRM is Creatio, formerly bpm'online. He loves C#, Javascript, web development, open source, and Linux. He also loves his hobby as an amateur filmmaker.

1 Comment

  1. We are runnng SalesLogix version with SQLServer

    Today we starting seeing this error when trying to check in reports in the Architect (version

    We are stuck

    Any ideas?


Submit a Comment

Your email address will not be published. Required fields are marked *

Subscribe To Our Newsletter

Join our mailing list to receive the latest Infor CRM (Saleslogix) and Creatio (bpm'online) news and product updates!

You have Successfully Subscribed!