Skip to Content.
Sympa Menu

freetds - Re: [freetds] TDS Version problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Robin Smith" <Robin AT ndigital.com>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] TDS Version problem
  • Date: Wed, 27 Feb 2008 16:58:59 -0500

Hi,

Thanks for the reply!

>> The versions on SLES are UnixODBC 2.2.11, PHP 5.1.2-29.54,
>> and Apache 2.2.3-16.15. I have installed FreeTDS v0.83.dev.20080208.
> Please, if you can download 0.82 branch or 0.82rc1.

Okay. I installed 0.82rc1 and the behaviour is still the same.

Incidentally, if I change to TDS Version 7.0, the page hangs and never
completes loading. If I tail the sql.log it seems to hang up after the query
but before the fetches like the lines below:

>> [ODBC][2535][SQLExtendedFetch.c][159]
>> Entry:
>> Statement = 0x8024bed0
>> Fetch Type = 1
>> Row = 1
>> PcRow = 0xbfc6473c
>> Row Status = 0xbfc6474a
>> [ODBC][2535][SQLExtendedFetch.c][316]
>> Exit:[SQL_ERROR]
>> DIAG [42000] [FreeTDS][SQL Server]sp_cursorfetch: The value
>> of parameter 'nrows' is invalid.

> I don't undestand why unixODBC says [ODBC] and not [unixODBC]...
> Probably it's a problem with client, which platform are you using? 32 or
> 64 bit ??
32-bit SLES10. UnixODBC, PHP5 and Apache were all installed through YAST
(SLES's package manager).

BTW, this log was created when running a PHP page that runs "odbc_"
functions, could this explain it? i.e. PHP5 has php5-odbc installed and this
uses unixODBC as its odbc library.

I mostly followed the instructions on this page:
http://www.unixodbc.org/doc/FreeTDS.html
(although I didn't do the SYBASE env variable, and I just did "./configure"
and let it detect everything on its own)

tsql -C -o v returns this:

Compile-time settings (established with the "configure" script)
Version: freetds v0.82RC1
freetds.conf directory: /usr/local/etc
MS db-lib source compatibility: no
Sybase binary compatibility: no
Thread safety: yes
iconv library: yes
TDS version: 5.0
iODBC: no
unixodbc: yes

Thanks again for any help getting this sorted out.

Robin

-----------------------
Robin Smith
Senior Manager, Information Technology
NDI
103 Randall Drive
Waterloo, ON, Canada N2V 1C5
Telephone: +1 (519) 884-5142 ext. 224
Toll Free: +1 (877) 634-6340
Global: ++ (800) 634-634-00
Facsimile: +1 (519) 884-5184
Website: www.ndigital.com ( http://www.ndigital.com/ )
----------------------




Archive powered by MHonArc 2.6.24.

Top of Page