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

Sebastien FLAESCH sf at 4js.com
Tue Jun 23 09:03:27 EDT 2015


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
>



More information about the FreeTDS mailing list