Skip to Content.
Sympa Menu

freetds - Re: [freetds] Default ANSI settings in FreeTDS odbc driver

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Default ANSI settings in FreeTDS odbc driver
  • Date: Sat, 24 Mar 2018 21:42:41 +0000

2018-03-22 12:08 GMT+00:00 LacaK <lacak AT zoznam.sk>:
> 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




Archive powered by MHonArc 2.6.24.

Top of Page