Skip to Content.
Sympa Menu

freetds - RE: [freetds] ODBC unit tests "funccall" and "transaction"

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] ODBC unit tests "funccall" and "transaction"
  • Date: Fri, 09 Jan 2004 20:29:41 -0000

Il ven, 2004-01-09 alle 17:46, Castellano, Nicholas ha scritto:
> > From: ZIGLIO Frediano [mailto:Frediano.Ziglio AT 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






Archive powered by MHonArc 2.6.24.

Top of Page