Skip to Content.
Sympa Menu

freetds - [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: 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




Archive powered by MHonArc 2.6.24.

Top of Page