Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Frediano Ziglio <freddyz77 AT tin.it>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11
  • Date: Tue, 20 Jun 2006 20:25:40 +0200

Il giorno mar, 20/06/2006 alle 13.54 -0400, entropy AT freetds.org ha
scritto:
> I'm getting a failure of the src/odbc/unittests/raiserror unit test.
>
> I am running FreeTDS 0.64RC2 with unixODBC 2.2.11.
>
> The database is "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
> "
>
> Client platform is RHEL 4 (Linux amarld16 2.6.9-22.ELsmp #1 SMP Mon Sep
> 19 18:32:14 EDT 2005 i686 athlon i386 GNU/Linux).
>
> freetds.conf excerpt:
>
> [global]
> tds version = 4.2
> initial block size = 512
> swap broken dates = no
> swap broken money = no
> cross domain login = no
> [mdreports]
> host = mdreports
> port = 15009
> tds version = 7.0
>
> Test failure output:
>
> $ ./raiserror
> odbctest
> --------
>
> connection parameters:
> server: 'mdreports'
> user: 'reportdbo'
> password: '????'
> database: 'reportdb'
> use reportdb
> CREATE PROCEDURE #tmp1
> @InParam int,
> @OutParam int OUTPUT,
> @OutString varchar(20) OUTPUT
> AS
> SET @OutParam = @InParam
> SET @OutString = 'This is bogus!'
> SELECT 'Here is the first row' AS FirstResult
> RAISERROR('An error occurred.', @InParam, 1)
> SELECT 'Here is the last row' AS LastResult
> RETURN (0)
> RAISERROR('An error occurred.', 5, 1)
> Result=0 DIAG REC 1: State=01000 Error=50000: [FreeTDS][SQL Server]An
> error occurred.
> Result=100 DIAG REC 1: State=00000 Error=0:
> SQLGetDiagRec error!
> $
>
>
> What's the currently recommended version of unixODBC to use with FreeTDS
> 0.64RC2?
>
> Freddy, I'd be specifically interested in hearing what version you are
> running, and whether the ODBC "raiserror" test works for you.
>
> Any other advice or ideas on what might be causing this failure would be
> appreciated.
>

I use this line to configure my tests

LDFLAGS='-lgcov' CFLAGS='-O0 -pipe -g -fprofile-arcs -ftest-coverage' sh
autogen.sh --enable-extra-checks --prefix=$HOME/install --with-odbc-nodm=/usr
--with-gnutls

in other words... no DM at all... if you think is stupid to always
suggest DM and do not use it I have to say that is a nightmare to make
all DMs happy so many time ago I decided to get rid of all these
problems and do not use for tests...

freddy77






Archive powered by MHonArc 2.6.24.

Top of Page