Michael Becker | 29 Jul 18:17 2015

Win32 Make


I am using
Visual Studio 2015
cmake 3.3.0-rc4


cmake -G "NMake Makefiles" .

does not find vsnprintf nor _vsnprintf
as result of this the file src\replacements\vasprintf.c can not be compiled
adding "#define _VSNPRINTF 1" to include\config.h solves the problem

is there a better solution?

Thanks: Michael
Attachment (m_becker.vcf): text/x-vcard, 135 bytes
Attachment (smime.p7s): application/pkcs7-signature, 5771 bytes
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
Randy Syring | 20 Jul 17:46 2015

Re: Appveyor Builds & Testing

Ha!  I forgot I opened that.

Are you making any progress on FreeTDS windows binaries?  FYI, we have a 
paid AppVeyor account which makes the builds go much faster vs the free 
version.  I could set up FreeTDS and pymssql on our account if you think 
that would be helpful.

FYI, we are going to PyOhio next weekend and I'm hoping to sprint on 
pymssql on Friday and Saturday night.  I'm thinking getting FreeTDS and 
pymssql appveyor support going might be a hug win for that sprint.

*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 07/18/2015 05:16 PM, Ramiro Morales wrote:
> Randy,
> There is, of course issse #303 you opened:
> https://github.com/pymssql/pymssql/issues/303
> I see now I had posted a comment with links there.
> On Fri, Jul 17, 2015 at 4:43 PM, Ramiro Morales <cramm0 <at> gmail.com> wrote:
>> Randy,
>> On Fri, Jul 17, 2015 at 1:33 PM, Randy Syring <randy <at> thesyrings.us> wrote:
>>> Ramiro,
(Continue reading)

Chuck Roberts | 8 Jul 18:17 2015

Cannot get tsql to connect

I'm trying to test my ODBC with Freetds installation and I can't get tsql
to connect. My end result is to use DBD::ODBC with Perl 5.18.2. In the
meantime I'm trying to test with tsql per FreeTDS instructions.

- Machine: Ubuntu 14.04.1 LTS 64-bit, it's a virtual machine.
- Several ODBC packages installed on Ubuntu. /etc/odbc.ini points to
driver: /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
- Trying to connect to MS SQL Server 2005 (yes, we know it will be
unsupported soon). Username is \domain\username, no password.
- FreeTDS 0.91 (most recent I could find)
- Output of tsql -C:
chuck <at> ubuntucomp:~/perl/gilson/jimv/fedex$ tsql -C
Compile-time settings (established with the "configure" script)
Version: freetds v0.91
freetds.conf directory: /etc/freetds
MS db-lib source compatibility: no
Sybase binary compatibility: yes
Thread safety: yes
iconv library: yes
TDS version: 4.2
iODBC: no
unixodbc: yes
SSPI "trusted" logins: no
Kerberos: yes

- In my /etc/freetds/freetds.conf, bottom part I added for my connection:
        host =
        port = 1433
        tds version = 7.0
(Continue reading)

Fergus Smith | 1 Jul 16:25 2015

ct-lib error handling


I've come across this same problem in every version of FreeTDS I've tried.

Running against MSSQL the error isn't trapped.
I think the ct-lib error handler isn't working properly.

The test environments are;

TDS version: 4.2

Version: freetds vdev.0.96.85

Windows 7 SP1

Sybase ASE 12.5.4

Microsoft SQL Server 2012 (SP1)

Running on windows against sybase this is the relevant part of the dump file;


ct.c:994:ct_send() succeeded

ct.c:1129:ct_results(0058B5C0, 0031A910)

token.c:549:tds_process_tokens(00588068, 0031A768, 0031A75C, 0x6914)

(Continue reading)

A. Craig West | 29 Jun 01:42 2015

Building as a DLL on Windows

I discovered that I require freetds to be buildable as a DLL file under
Windows, so I have modified the Nmakefile to add some new build targets and
directories. After I have tested it a bit, I will port my changes up to
I am also getting a fault in the compiler on one of the files, but have not
investigated the cause yet. It is possible that the issue is already
resolved in head. I am currently building with Visual Studio 2008 command
Jas anybody else dealt with similar issues lately? It seems to have been a
while since anybody tried to build DLL's, although it turned out to be
pretty easy to implement...
Sebastien FLAESCH | 21 Jun 09:04 2015

Re: Testing 0.95

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...

>> So far, my QA tests ran ok against SQL Server 2005, will test on other
(Continue reading)

Ray Rankins | 20 Jun 15:18 2015

0.91 freebcp performance

Just tested running a large bcp with 0.91 freebcp and the performance was awful.
Took 1.5 hours to load 5 million rows (conversely, Sybase bcp loaded the same file in 1.5 minutes). 
Is there some setting that might be on during compile that would cause freebcp to run slow.
I checked and double checked that the debug flags were not enabled (have made that mistake before) and they
were not.
Are there any compile time options that could slow down freebcp that I should make sure are disabled when I
compile it?

Frediano Ziglio | 20 Jun 02:49 2015

Progress on AppVeyour

Hi Ramiro,
  I'm following your progress on AppVeyor, quite interesting.

Some things I notes:
- you register odbc driver with odbcconf, you can use regsvr32, the
driver should be able to register itself. Strange to use this program
for registering an odbc driver instead of a COM component but I added
this feature;
- iconv seems not compiled (as tsql output), looks like some checks
are not done in CMakeLists.txt and so some variable are not defined
- similar for ODBC, on 64 bit for instance you get lot of problems as
some define are not there (like HAVE_SQLLEN). Not your fault but can
cause problems.

I also added a fix for thread declatation, I'll look forward to see
results from next compile with updated master to to check if they
disappeared. It's a pity a thread returns a DWORD instead of a
DWORD_PTR it's useful to pass a pointerand thread process data passes
and return other data with another pointer.

Randy Syring | 19 Jun 14:40 2015



Any chance FreeTDS could switch to semver for versioning?  I think the current logorithmic? method is kind
of geeky (in a cool way), but likely causes more confusion than it's worth.

*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)/
Sebastien FLAESCH | 19 Jun 12:53 2015

XML type returns SQL_CHAR type

Seems that when using the XML type, SQLDescribeCol() returns SQL_CHAR, and
precision=2147483647 ... expected?

BTW what are [N]VARCHAR(MAX) types supposed to return in SQLDescribeCol()?

Sebastien FLAESCH | 19 Jun 11:49 2015

DATE, TIME and DATETIME2 support


Where can I find binding samples using DATE, TIME and DATETIME2?

I could not find SQL_SS_TIME2_STRUCT in the header files...

(Check sqlncli.h from SQL Server Native client)