Re: Testing 0.95: What TDS version for SQL Server 2012 / 2014?

Sebastien FLAESCH <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Organization Four Js Development Tools
Message-ID <[email protected]>
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" <[email protected]> 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
>> [email protected]
>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>
>
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.