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: Randy Syring <randy AT thesyrings.us>
  • 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 09:24:07 -0400

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