Skip to Content.
Sympa Menu

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

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] Testing 0.95: What TDS version for SQL Server 2012 / 2014?
  • Date: Tue, 23 Jun 2015 21:25:11 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page