freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
Re: [freetds] Default ANSI settings in FreeTDS odbc driver
- 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
-
[freetds] Default ANSI settings in FreeTDS odbc driver,
LacaK, 03/22/2018
-
Re: [freetds] Default ANSI settings in FreeTDS odbc driver,
Frediano Ziglio, 03/24/2018
- Re: [freetds] Default ANSI settings in FreeTDS odbc driver, LacaK, 03/26/2018
-
Re: [freetds] Default ANSI settings in FreeTDS odbc driver,
Frediano Ziglio, 03/24/2018
Archive powered by MHonArc 2.6.24.