We have an older application running at Watcom 3.2 database.
The application is One Write Plus 8.0.

While entering a transaction, the program locked up and
appears to have caused a problem in the database. Most
modules work and can view database entries except a couple.
We are getting a TR_EDITFLG error in One Write Plus.

I feel that there is a hung transaction. Is there a way to
connect to the DB and view/modify records? Is there a way to
rollback and transactions?

Version 3.2 is even before my time, although there are still a few folks
here who are older than me. ;-)

If you shut down the database engine that will force any open transactions
to rollback. Restarting the engine will recover back to the end of the last
committed transaction. If you are still having problems at that point, then
you will want to check what the engine output shows to verify that it is not
reporting any errors. Since other application modules seem to work, the
database is probably still healthy.

To access the database outside of the application you will need the isql.exe
utility and a user ID and password for the database. Note that the
application vendor may not have provided ISQL with the application.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx...c?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

<Josh> wrote