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

Frediano Ziglio freddy77 at gmail.com
Tue Jun 23 16:25:11 EDT 2015


2015-06-23 14:03 GMT+01:00 Sebastien FLAESCH <sf at 4js.com>:
> 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
> ???
>

SQL_VARCHAR is fine. precision should be 0 for 7.2+. There is a test
for this and for me returns 0! Are you sure you did everything
correct?

> 7.1    TIME(3)           -9 ???                  12             0 (should be
> 3)
> 7.2    TIME(3)           -9 ???                  12             0 (should be
> 3)

yes, server return it as a string so 12 is the string length. Scale is
obviously 0.

> 7.3    TIME(3)           -154 (SQL_SS_TIME2/ok)  12             0 (should be
> 3)
>

beside scale other information are fine.

> What TDS version should I use with SQL Server 2014?
>

7.3 is fine. master support 7.4 but there are no improvements (support
some session recovery which are not implemented anyway)

> Is there a doc reference somewhere?
>
> Same problems with SQL Server 2012 ...
>

sql 2012 and sql 2014 use same protocol (7.4) but as I said using sql
2008 protocol is perfectly fine.

> Seb
>

Frediano

> 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
>>>>


More information about the FreeTDS mailing list