Re: Error while using JDBCR4 Service Program

Charles wrote:

Is the MS SQL Server running in "auto-commit"?

Charles, it looks like you are spot on.

I plan to try some kind of SET statement, but have some confusion
with an MSDN lib article stating:

"When ON, SET IMPLICIT_TRANSACTIONS sets the connection to
implicit transaction mode."
"When OFF, it returns the connection to autocommit transaction
mode."

I prefer something less ambiguous; something not dependent on the current
connection state.

I think am looking for a way to start an "explicit transaction" on Sql
Server.