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: 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 15:03:27 +0200

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






Archive powered by MHonArc 2.6.24.

Top of Page