[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

SQL_AUTOCOMMIT



I'm doing a migration from SQR 3 to SQR 5.1 and i'm
using the Brio.Report Builder for coding and for
lunching the Reports the executable:
\sqribe\sqr\odb\binw\sqrw.exe(SQR 5.1).My database is
SQLSERVER 7.
When I lunch a report of SQR 3 with this executable
the following error appear:

 "(SQR 5528) ODBC SQL dbexec: SQLExecute error 0 in
cursor 2:
   [INTERSOLV][ODBC MS SQL Server 6 driver]You cannot
have more than one statement active, when
SQL_AUTOCOMMIT is false.

Error on line 389:
   (SQR 3735) Could not execute SQL.

 Cursor #2:
   SQL = CONVERT(FLOAT, ROUND(CONVERT(MONEY, ?), ?))
@Result let ? = @Result
 Compiles = 1
 Executes = 0
 Rows     = 0 "


Any help is grateful.

Excuse my possibles mistakes with the English.

                                    Málaga(Spain)

_______________________________________________________________
Do You Yahoo!?
Consiga gratis su dirección @yahoo.es en http://correo.yahoo.es