FreeTDS Development Group

["Richard Head Jr." <hsomob1999 AT yahoo.com>]

--- On Mon, 8/2/10, Frediano Ziglio <freddy77 AT gmail.com> wrote:
> 2010/7/30 Richard Head Jr. <hsomob1999 AT yahoo.com>:
> > I downloaded it (freetds-0.82.1.dev.20100729), `make
> check` has the same problem:
> 
> Update snapshot again... I hope this time works...
> 

Yes it worked, though the done_handling test failed:

found wcinvent-install-test.ASDB_Dev for wbla in "../../../PWD"
SQL text will be read from ./done_handling.sql
Msg 5701, Level 0, State 2
Server 'SQL-TEST',
        Changed database context to 'ASDB_Dev'.
Msg 5703, Level 0, State 1
Server 'SQL-TEST',
        Changed language setting to us_english.
Msg 5701, Level 0, State 1
Server 'SQL-TEST',
        Changed database context to 'ASDB_Dev'.
          1: create table #dummy (s char(10))
          1: insert into #dummy values('xxx')
          1: if object_id('done_test') is not NULL drop proc done_test
          1: create proc done_test @a varchar(10) output
          2: as
          3:    select * from #dummy
          1: if object_id('done_test2') is not NULL drop proc done_test2
          1: create proc done_test2
          2: as
          3:    select * from #dummy where s = 'aaa'
          4:    select * from #dummy
normal row with rowcount on
          1: select * from #dummy       /* normal row */
State sqlexec         SUCCEED              COLS(1)
State nextrow         NO_MORE_ROWS         COLS(1)
State nextrow         NO_MORE_ROWS         COLS(1)
State results         SUCCEED              COLS(1)
State nextrow         REG_ROW/MORE_ROWS    COLS(1) DATA IDLE
State nextrow         NO_MORE_ROWS         IDLE
State results         SUCCEED
State nextrow         NO_MORE_ROWS
State results         NO_MORE_RESULTS
State more results?   NO_MORE_RESULTS
turn rowcount off
          1: set nocount on
normal row with rowcount off
          1: select * from #dummy       /* normal row with no count */
State sqlexec         SUCCEED              COLS(1)
State nextrow         NO_MORE_ROWS         COLS(1)
State nextrow         NO_MORE_ROWS         COLS(1)
State results         SUCCEED              COLS(1)
State nextrow         REG_ROW/MORE_ROWS    COLS(1) DATA
State nextrow         NO_MORE_ROWS         COLS(1) DATA
State results         NO_MORE_RESULTS      COLS(1) DATA
State more results?   NO_MORE_RESULTS      COLS(1) DATA
turn rowcount back on
          1: set nocount off
normal row without rows
          1: select * from #dummy where 0=1     /* normal row without rows */
State sqlexec         SUCCEED              COLS(1)
State nextrow         NO_MORE_ROWS         COLS(1) ROWS(0)
State nextrow         NO_MORE_ROWS         COLS(1) ROWS(0)
State results         NO_MORE_RESULTS      COLS(1) ROWS(0)
State nextrow         NO_MORE_ROWS         COLS(1) ROWS(0)
State nextrow         NO_MORE_ROWS         COLS(1) ROWS(0)
State results         NO_MORE_RESULTS      COLS(1) ROWS(0)
State more results?   NO_MORE_RESULTS      COLS(1) ROWS(0)
error query
          1: select dklghdlgkh from #dummy      /* error query */
Msg 207, Level 16, State 3
Server 'SQL-TEST',
        Invalid column name 'dklghdlgkh'.
DB-Library error (severity 16):
        General SQL Server error: Check messages from the SQL Server
Operating-system error:
        FAIL: done_handling


The SQL Server error log contained: Invalid buffer received from client

I'm running SQL Server 2000. 

Thanks for your assistance.