FreeTDS Development Group

["Robin Smith" <Robin AT ndigital.com>]

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