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

Randy Syring randy at thesyrings.us
Tue Jun 23 09:24:07 EDT 2015


Sebastian,

More info on TDS protocols are here:

http://www.freetds.org/userguide/choosingtdsprotocol.htm

Microsoft servers are backwards compatible with previous TDS versions 
but you should generally use the latest TDS version supported by the 
server in order to get support for that server's capabilities 
(varchar(max), date, time, etc.).

*Randy Syring*
Husband | Father | Redeemed Sinner

/"For what does it profit a man to gain the whole world
and forfeit his soul?" (Mark 8:36 ESV)/

On 06/23/2015 09:03 AM, Sebastien FLAESCH wrote:
> 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
>>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS at lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>



More information about the FreeTDS mailing list