FreeTDS Development Group

[Daniel Schwager <Daniel.Schwager AT dtnet.de>]

James K. Lowden freetds AT lists.ibiblio.org  wrote:
> Daniel, 
> 
> Perhaps in certain cases the output coming back from the server confuses
> FreeTDS.  The DBI traces don't have enough detail to make that clear.  

> Please turn on the FreeTDS log (TDSDUMP) and post the last 500 lines or so
> (for a failed case).  If there's a protocol-level problem, it will show up
> there.  

Hallo James,

you asked for some DUMP-Files ....

/etc/freetds.conf:
        dump file = /var/log/freetds.log
        debug level = 10

Here we are (-: 3 x Attachments )

regards
Danny



- Die 31.12.2002 12:21, danny

***** CASE 2:
*stdout:
Query: select RemainingUnits from distInfo where PROJECTID = '02061301' AND 
TASKKEY = '93' AND RESOURCEKEY = 'dts' AND START1 = 'DEC 30 2002 12:00AM'
ct_res_info() returned 0 columns at 
/usr/lib/perl5/site_perl/5.005/i586-linux/DBI.pm line 1253.
dbih_setup_fbav: invalid number of fields: -29744, NUM_OF_FIELDS attribute 
probably not set right at /usr/lib/perl5/site_perl/5.005/i586-linux/DBI.pm 
line \
1577.

* FAILED
FREETDS-Dump:
Attachment: freetdsdump-case2.txt


***** CASE 3:
*stdout
sql: select TASKKEY, RESOURCEKEY, SUM(ActualUnits) from distInfo  where 
PROJECTID = '02061301'  group by TASKKEY, RESOURCEKEY
ct_res_info() returned 0 columns at sdi_control_sdi2ps8.pm line 195.
go 1
dbih_setup_fbav: invalid number of fields: -400, NUM_OF_FIELDS attribute 
probably not set right at sdi_control_sdi2ps8.pm line 202.

*FAILED
Attachment: freetdsdump-case3.txt


***** CASE 1:
*stdout
sql: select TASKKEY, RESOURCEKEY, SUM(ActualUnits) from distInfo  where 
PROJECTID = '02061301'  group by TASKKEY, RESOURCEKEY
Speicherzugriffsfehler

*FAILED
Attachment: freetdsdump-case1.txt



-- 
------------------------------------------------------------
DT Netsolution GmbH -  Talaeckerstr. 30 -  D-70437 Stuttgart
Tel: +49-711-849910-32               Fax: +49-711-849910-932
WEB: http://www.dtnet.de/           email: schwager AT dtnet.de

Attachment: freetdsdump-case1.txt.gz
Description: GNU Zip compressed data

Attachment: freetdsdump-case2.txt.gz
Description: GNU Zip compressed data

Attachment: freetdsdump-case3.txt.gz
Description: GNU Zip compressed data