[prev in list] [next in list] [prev in thread] [next in thread] 

List:       freetds
Subject:    RE: [freetds] ODBC unit tests "funccall" and "transaction"
From:       Frediano Ziglio <freddyz77 () tin ! it>
Date:       2004-01-09 20:29:37
Message-ID: 1073680176.3422.19.camel () freddy
[Download RAW message or body]

Il ven, 2004-01-09 alle 17:46, Castellano, Nicholas ha scritto:
> > From: ZIGLIO Frediano [mailto:Frediano.Ziglio@vodafone.com] 
> > Sent: Friday, January 09, 2004 10:22 AM
> > 
> > I really don't understand. I tried using unixODBC 2.0.4 with TDS
> > 7.0/8.0... still no error...
> > Anyone can post a TDSDUMP and/or test output??
> 
> Well I've realized that most of my previous tests were probably meaningless.
> I forgot that one needs to install FreeTDS before "make check" can do
> anything useful with ODBC (at least in my setup...with "Driver          =
> /usr/local/lib/libtdsodbc.so" in /usr/local/etc/odbcinst.ini ...)
> 
> So, I've changed a whole bunch of variables at once:  upgraded to
> unixODBC-2.2.7, updated to latest FreeTDS sources with Freddy's workaround,
> compiled and installed FreeTDS, and now things have got worse.  Five ODBC
> tests now fail against both Sybase and SQL servers, on my 32-bit NetBSD
> system.
> 
> I really don't have the time or knowledge to debug any of this properly.
> But I do think something is very wrong, and I think shipping a FreeTDS
> release this weekend would be a big mistake.  But that's just my opinion.
> 
> I have attached test output from a run against a Sybase server.
> 

About last test (funccall)

odbctest
--------

connection parameters:
server:   'stpmdb'
user:     'scbdp'
password: '????'
database: 'pmdb'
use pmdb
drop proc simpleresult
Unable to execute statement
create proc simpleresult @i int as begin return @i end
DECLARE @i INT
drop proc simpleresult
drop proc simpleresult2
create proc simpleresult2 @i int, @x int output, @y varchar(20) output
as begin select @x = 6789 select @y = 'test foo' return @i end
Unable to execute statement
FAIL: funccall

First "drop proc simpleresult2" doesn't fail... This means you have
already a simpleresult2 procedure. I'll force cursor close here too
(like transaction issue).

freddy77


_______________________________________________
FreeTDS mailing list
FreeTDS@lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds
[prev in list] [next in list] [prev in thread] [next in thread]