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:35:39 +0100

We're guessing that the working version could have been 53rc1 from a backup
listing.

Mssql_query is returning true so it likes the query (we tried breaking the
query and it returns false.

We tried changing the string to "set rowcount 5\n select * from sometable"
but this makes no difference.

(This is a generic piece of code and the ability to run queries with the set
rowcount in the query is important).

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




Archive powered by MHonArc 2.6.24.

Top of Page