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

entropy at freetds.org entropy at freetds.org
Tue Jun 20 13:54:03 EDT 2006


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



More information about the FreeTDS mailing list