Skip to Content.
Sympa Menu

freetds - RE: [freetds] Issue with freetds 0.61.2 ok on prior version which was <0.60

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Steve Hanselman <SteveH AT brendata.co.uk>
  • To: "'FreeTDS Development Group'" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Issue with freetds 0.61.2 ok on prior version which was <0.60
  • Date: Thu, 4 Sep 2003 18:53:48 +0100

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)"

So I guess that the new version doesn't like something about the query.

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.

I've attached a freetds.log (gzip'd) if that helps.

For now I'll make some code changes to work around it.

Regards

Steve



-----Original Message-----
From: Steve Hanselman [mailto:SteveH AT brendata.co.uk]
Sent: 04 September 2003 18:17
To: 'freetds AT lists.ibiblio.org'
Subject: [freetds] Issue with freetds 0.61.2 ok on prior version which was
<0.60

Using php4 (4.3.3) to a Microsoft 6.5 SQL Server we could previously run two
commands in a string and the results were returned correctly



E.g. "set rowcount 5 select * from sometable"



Mssql_fetch_array now returns false the first time it is called (presumably
wrongly handling the result set).

Tried using mssql_fetch_object but that returns nothing either.



We are using Sybase-ct as the method.



This previously worked ok on a version that was lower than 0.60 (I'm sorry I
don't know the version, we were running this for a week then deleted the old
version before noticing this issue).



Nothing has changed in the freetds.conf (ver=4.2)



Any ideas on what else to look for?



Regards



Steve



Steve Hanselman

Brendata (UK) Ltd



Tel: +44 (0)1268 466111

Fax: +44 (0)870 1387283

Mob: +44 (0)7973 750993









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
_______________________________________________
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

Attachment: freetds.log.gz
Description: Binary data




Archive powered by MHonArc 2.6.24.

Top of Page