SQLServer Error

[Bruce Mitchell <mitchellb@CYBERUS.CA>]

Hello all,

I've come across a very strange error that, hopefully, someone else has
encountered.  I'm developing SQR reports for a PeopleSoft Application run on
MS SQLServer.  The error message is as follows

(SQR 5528) ODBC SQL dbexec: SQLExecute error 610 in cursor 11:
   [Microsoft][ODBC SQL Server Driver][SQL Server]

Maximum number of databases that may be accessed by a transaction is 8.
This number has been exceeded by this query.

Error on line 1105:
   (SQR 3723) Problem executing cursor.

SQRW: Program Aborting.
(SQR 5528) ODBC SQL dbxact: SQLTransact error 0 in cursor 0:
   [Microsoft][ODBC SQL Server Driver]Communication link failure


When I cut the code out of the SQR and run it in ISQLW (MS SQLServer query
tool) it works fine, but gives the above error every time I run it in SQRW.
I am only accessing one database, not eight, and the code is fairly
straightforward.

Any ideas?

thanks,
Bruce