Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 09 Mar 2011 @ 15:03:45 GMT


     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 


Subj:   ODBC disconnect
 
From:   DWellman

Hi all,

Has anyone noticed the following - and do you know the cause / resolution ?

Using ODBC as the api, when the program disconnects from the dbms the session stays on the dbms for a few minutes (1-2 minutes). This is on a completely idle system apart from this one ODBC session and a second session which is there simply to monitor what is happening. Neither session is doing any processing.

I've tried this on two DBMS releases, 13.0.0.2 and 13.0.0.19.

I've tried this using ODBC drivers 13.0.0.2, 13.10.0.2 and 13.10.0.5.

I'm using SQL Assistant 13.10.0.3 as my odbc application.

If I connect using dot net data provider from the same SQL Assistant or using cli (Bteq, my own code etc) then the session disappears from the DBMS immediately.

It sounds like an ODBC bug to me but I thought I'd ask if anyone else has come across this yet.


Cheers,

Dave

Ward Analytics Ltd: Information in motion (www.ward-analytics.com)



     
  <Prev Next>  
<<First
<Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016