Driver Properties

James K. Lowden jklowden at speakeasy.org
Wed Apr 4 22:12:40 EDT 2001


Nik Petroff wrote:

> Is it possible to set the connection properties so that ANSI_NULLS and
> ANSI_WARNINGS are on? I can't find any java code for this anywhere so an
> example would be great.

Could you just execute this query when you establish a connection?

    set ANSI_NULLS on
    set ANSI_WARNINGS on

Those settings stay in effect for the session.

HTH.

--jkl




More information about the FreeTDS mailing list