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: Wed, 24 Jun 2015 21:13:32 +0100

Il 24/Giu/2015 15:16, "Sebastien FLAESCH" <sf AT 4js.com> ha scritto:
>
> On 06/23/2015 10:25 PM, Frediano Ziglio wrote:
>>
>> 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?
>
>
> I am using the same code in Easysoft and SQL Native Client:
>
> SQLULEN precision;
>
> Note that I am connected to SQL Server 2014 and that tdsdump shows:
>
> token.c:1533:tds7_get_data_info:
> colname = t
> type = 39 (varchar)
> server's type = 167 (xvarchar)
> column_varint_size = 8
> column_size = 1073741823 (1073741823 on server)
>
> ...
>

Please try SQLDescribeCol. Libtds have slightly different point of view.
As stated from Ms documentation varchar max is returned as varchar with
size 0 (unlimited). Same for freetds.
>
>>
>>> 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.
>

I'll do other test. We can fix it.

Frediano

>
> I can deal with this based on the precision.
>
>
>>
>>> 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
>>>>>>
>> _______________________________________________
>> 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




Archive powered by MHonArc 2.6.24.

Top of Page