Tag Info

New answers tagged


As I understand it, your development team got the error when using DbVisualizer with JTOpen (jt400.jar) for direct connections to the database. I got the same exception with DBvis ver 9.1.10. The tool took a long time when clicking the connect button, then finally showed error code -99999. What I do to fix this is to disable the Proxy setting of DBvis: ...


In addition to setting Local DTC Properties, you need to open the firewall on both machines to allow program Distributed Transaction Coordinator to go thru. When testing T-SQL in Query Editor Window, make sure to turn on XACT_ABORT as suggested by Microsoft. XACT_ABORT must be set ON for data modification statements in an implicit or explicit ...

Top 50 recent answers are included