Re: SQLServer Error

[Chris Snow <chris_snow@EMAIL.MSN.COM>]

Can you send a sample of your code?  Run with the -s flag and take a look at
the query causing the problem (cursor 11).  What does it say?

Chris

-----Original Message-----
From: Bruce Mitchell <mitchellb@CYBERUS.CA>
To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
Date: Friday, April 17, 1998 4:31 PM
Subject: SQLServer Error


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