Fergus Smith | 1 Jul 16:25 2015
Picon

ct-lib error handling

Hi,

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

http://lists.ibiblio.org/pipermail/freetds/2007q3/022165.html
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
Picon

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
head.
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
line.
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...
-Craig
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...

Seb
>> 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?

-Ray
Frediano Ziglio | 20 Jun 02:49 2015
Picon

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

Frediano
Randy Syring | 19 Jun 14:40 2015
Picon

semver?

Frediano,

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()?

Seb
Sebastien FLAESCH | 19 Jun 11:49 2015

DATE, TIME and DATETIME2 support

Hello,

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)

Seb
Sebastien FLAESCH | 19 Jun 11:01 2015

Testing 0.95

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

Is there an configure option to turn on gcc's address sanitizer?
We are using this option in our product.

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!

Cheers
Seb
Making clean in include
make[1]: Entering directory '/opt3/dbs/tds/tmp/freetds-0.95.5/include'
Making clean in freetds
make[2]: Entering directory '/opt3/dbs/tds/tmp/freetds-0.95.5/include/freetds'
rm -rf .libs _libs
rm -f *.lo
make[2]: Leaving directory '/opt3/dbs/tds/tmp/freetds-0.95.5/include/freetds'
make[2]: Entering directory '/opt3/dbs/tds/tmp/freetds-0.95.5/include'
rm -rf .libs _libs
rm -f *.lo
make[2]: Leaving directory '/opt3/dbs/tds/tmp/freetds-0.95.5/include'
make[1]: Leaving directory '/opt3/dbs/tds/tmp/freetds-0.95.5/include'
(Continue reading)

Alistair Roberts | 16 Jun 00:42 2015
Picon

FreeTDS and SQL 2014 In-Memory tables

Hi,

Has anyone tried FreeTDS and SQL 2014's in memory table option? 

Like to know if it's possible to get it to work or not.

Thanks

Al

		

Alistair Roberts
SENIOR SQL SERVER DBA

Email:   

 <mailto:alistair.roberts <at> ladbrokes.com.au>
alistair.roberts <at> ladbrokes.com.au

Support:   

1300 523 276

Betting:   

1800 523 276

1300 LADBROKES | 461-473 Lutwyche Road, Lutwyche, 4030 |
<http://www.ladbrokes.com.au/> www.ladbrokes.com.au
(Continue reading)

Craig A. Berry | 12 Jun 19:48 2015
Picon

[PATCH] Two VMS configuration nits

There are two attached patches.  One avoids a redefinition of a symbol in the VMS-specific Makefile
equivalent which bothers one VMS make utility (MMS) but not another (MMK).  The other enables the
replacement socketpair for older VMS systems that don’t have their own.  These are against master but
should be quite safe for the 0.95 branch as well.

Thanks to Norm Lastovica for problem reports and testing.
________________________________________
Craig A. Berry
mailto:craigberry <at> mac.com

"... getting out of a sonnet is much more
 difficult than getting in."
                 Brad Leithauser


_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Gmane