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: Sebastien FLAESCH <sf AT 4js.com>
  • To: Randy Syring <randy AT thesyrings.us>, 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 16:15:05 +0200

Thank you Randy, but according to my tests, VARCHAR(MAX) works with TDS 7.1,
but not with 7.3, and I want to use 7.3 to have datetime2(n)/time(n) support.

I see also that SQL Server 2012 / 2014 are not listed in the
choosingtdsprotocol.htm
page... would be nice that someone clarifies if these server versions are
supported.

S.

On 06/23/2015 03:24 PM, Randy Syring wrote:
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







Archive powered by MHonArc 2.6.24.

Top of Page