[freetds] Testing 0.95: What TDS version for SQL Server 2012 / 2014?

Sebastien FLAESCH sf at 4js.com
Tue Jun 23 10:15:05 EDT 2015


Thank you Randy, but according to my tests, VARCHAR(MAX) works with TDS 7.1,
but not with 7.3, and I want to use 7.3 to have datetime2(n)/time(n) support.

I see also that SQL Server 2012 / 2014 are not listed in the choosingtdsprotocol.htm
page... would be nice that someone clarifies if these server versions are supported.

S.

On 06/23/2015 03:24 PM, Randy Syring wrote:
> Sebastian,
>
> More info on TDS protocols are here:
>
> http://www.freetds.org/userguide/choosingtdsprotocol.htm
>
> Microsoft servers are backwards compatible with previous TDS versions but you should generally use the latest TDS version supported by the server in
> order to get support for that server's capabilities (varchar(max), date, time, etc.).
>
> *Randy Syring*
> Husband | Father | Redeemed Sinner
>
> /"For what does it profit a man to gain the whole world
> and forfeit his soul?" (Mark 8:36 ESV)/
>
> On 06/23/2015 09:03 AM, Sebastien FLAESCH wrote:
>> I connect to SQL Server 2014 using FreeTDS 0.95.5 from a Linux Debian 64b...
>>
>> To me SQLDescribeCol() returns unusable type info...
>>
>> According to the TDS_Version, I different (incompatible) type info:
>>
>> TDS    Column Type       sqltype                 precision scale
>> ---------------------------------------------------------------------------------
>> 7.1    VARCHAR(MAX)      -1 (SQL_LONGVARCHAR)    2147483647 0          (ok)
>> 7.2    VARCHAR(MAX)      12 (SQL_VARCHAR)        1073741823 0          ???
>> 7.3    VARCHAR(MAX)      12 (SQL_VARCHAR)        1073741823 0          ???
>>
>> 7.1    TIME(3)           -9 ???                  12             0 (should be 3)
>> 7.2    TIME(3)           -9 ???                  12             0 (should be 3)
>> 7.3    TIME(3)           -154 (SQL_SS_TIME2/ok)  12             0 (should be 3)
>>
>> What TDS version should I use with SQL Server 2014?
>>
>> Is there a doc reference somewhere?
>>
>> Same problems with SQL Server 2012 ...
>>
>> Seb
>>
>> On 06/21/2015 09:04 AM, Sebastien FLAESCH wrote:
>>> Hi Frediano!
>>>
>>> On 06/20/2015 12:33 PM, Frediano Ziglio wrote:
>>>> Il 19/Giu/2015 10:33, "Sebastien FLAESCH" <sf at 4js.com> ha scritto:
>>>>>
>>>>> Hi all,
>>>>>
>>>>> Just installed 0.95.5 got from: ftp://ftp.freetds.org/pub/freetds/stable/
>>>>> (I guess this is the latest stable version?)
>>>>>
>>>>> Attached some compilation warnings...
>>>>>
>>>>
>>>> Yes, no problems
>>>>
>>>>> Is there an configure option to turn on gcc's address sanitizer?
>>>>
>>>> Just define CFLAGS properly calling configure.
>>>>
>>>>> We are using this option in our product.
>>>>>
>>>>
>>>> For production?? You known is not meant for production? It slows down quite
>>>> a lot.
>>>
>>> No of course it's just for internal compilation, production releases
>>> are compiled with optimization flags...
>>>
>>> Seb
>>>>> So far, my QA tests ran ok against SQL Server 2005, will test on other
>>>> servers.
>>>>>
>>>>> Seems that new datetime data types are now supported which is good news!
>>>>>
>>>>
>>>> As stated in the news :)
>>>>
>>>>> Cheers
>>>>> Seb
>>>>>
>>>>
>>>> Frediano
>>>> _______________________________________________
>>>> FreeTDS mailing list
>>>> FreeTDS at lists.ibiblio.org
>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>
>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS at lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>
>> _______________________________________________
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>



More information about the FreeTDS mailing list