freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11
- From: entropy AT freetds.org
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11
- Date: Tue, 20 Jun 2006 13:54:03 -0400
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.
--
Cheers,
entropy
-
[freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11,
entropy, 06/20/2006
-
Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11,
Frediano Ziglio, 06/20/2006
- Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11, Christos Zoulas, 06/20/2006
- Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11, entropy, 06/20/2006
- Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11, James K. Lowden, 06/21/2006
-
Re: [freetds] FreeTDS 0.64RC2 src/odbc/unittests/raiserror failure with unixODBC 2.2.11,
Frediano Ziglio, 06/20/2006
Archive powered by MHonArc 2.6.24.