FreeTDS Development Group

[Steve Hanselman <SteveH AT brendata.co.uk>]

Thanks for that, I'll pull the CVS now and reply ASAP.

(Had to get the workaround in yesterday as I'd screwed a system!  It's
modular so I can easily reverse it for testing.)

Steve


-----Original Message-----
From: Lowden, James K [mailto:LowdenJK AT bernstein.com] 
Sent: 04 September 2003 20:10
To: 'FreeTDS Development Group'
Subject: RE: [freetds] Issue with freetds 0.61.2 ok on prior version which
was <0.60

> From: Steve Hanselman [mailto:SteveH AT brendata.co.uk]
> Sent: September 4, 2003 1:54 PM
> 
> Ok, a bit more testing.
> 
> When the two part query is run, the mssql_query returns true 
> (according to
> var_dump) but when a single part query is run it returns 
> 
> "resource(9) of type (sybase-ct result)"

Steve, 

Please try the latest snapshot before you start your workaround.  

I think this problem was very carefully investigated over the summer and is
fixed in CVS.  I think it's related to our ct-lib handling of empty result
sets or of queries that don't return results.  You'll find more in the
archives on the topic.  

If this is still an outstanding problem, we need to fix it before the next
release.   

> The weird thing is that if you tcpdump and capture traffic on 
> 1433 then you
> do see the results coming back, likewise you can see them in 
> the freetds debug trace.

Right.  That's because the server is sending the results correctly, but the
ct-lib (or possibly libtds) code is incorrectly interpreting the TDS stream.


Thanks.  

--jkl
-----------------------------------------
The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the
original message. Please note that we do not accept account orders and/or
instructions by e-mail, and therefore will not be responsible for carrying
out such orders and/or instructions.


_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

The information contained in this email is intended for the personal and 
confidential use
of the addressee only. It may also be privileged information. If you are not 
the intended
recipient then you are hereby notified that you have received this document 
in error and
that any review, distribution or copying of this document is strictly 
prohibited. If you have 
received  this communication in error, please notify Brendata immediately on: 

+44 (0)1268 466100, or email 'technical AT brendata.co.uk' 

Brendata (UK) Ltd
Nevendon Hall, Nevendon Road, Basildon, Essex. SS13 1BX  UK
Registered Office as above. Registered in England No. 2764339

See our current vacancies at www.brendata.co.uk