Re: Default ANSI settings in FreeTDS odbc driver

Frediano Ziglio <[email protected]> Sat, 24 Mar 2018 21:42:41 +0000

Newsgroups	gmane.comp.db.tds.freetds
Message-ID	<CAHt6W4cJ9xCEt1Kv9knvS-99KQBbi0_myWVUjTgQ=G7n=Nj49A@mail.gmail.com>

2018-03-22 12:08 GMT+00:00 LacaK <[email protected]>:
> Hi *,
>
> are there any default settings, which FreeTDS odbc driver set-ups upon
> connection ?
>
> |setquoted_identifier setansi_warnings setansi_padding setansi_nulls
> setconcat_null_yields_null In my case INSERT on table with filtered index
> fails with error message, that above mentioned settings must be ON. This
> happens only on Linux with FreeTDS odc driver, on Windows with Microsoft
> driver this does not happen (so I guess that MS already sets these ANSI
> settings by default) Is there way how to set them in any INI file ? Or
> should I only send commands: ||"setquoted_identifier ON; setansi_warnings
> ON; setansi_padding ON; setansi_nulls ON; setconcat_null_yields_null ON;" |
> Thanks
> -Laco.
>

Weird, they should have the same settings. There's a bit in the login
packet that should set odbc/others like settings, if you use the odbc
driver this bit should be compatible with Microsoft drivers.

Frediano