[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:20:43
Message-ID: 1073679441.3422.11.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.
> 
> Cheers,
> --nick
> 

:((( Yes and no... going deeply with problem I realized that I was using
2.2.6 version, not 2.2.7... Doing debugging (using compiled unixODBC
with debug info) I realized that last updates do not handle  state
change very well (see line remove the SQLNumResults call in unixODBC
ChangeLog on website). For this reason SQLMoreResults works but next
SQLFetch ALWAYS fails (without even calling driver) so multiple records
do not work as expected... also a metadata function fails if called
after a SQLExecDirect... These test:
- t0003
- tables
- moreandcount
- earlybind
are so expected to fail using unixODBC 2.2.7 due to unixODBC bugs. So we
left with only funccall test (as before).

I'm sorry to have wasted your time...

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]