Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 24 Feb 2004 @ 23:09:59 GMT

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

Subj:   Re: Query Timeout question
From:   Cooper, Craig E

Similar follow up question for this thread.

In a global.asa file the following sub sets timeout values...

        Sub Application_OnStart
                Application("Sweeps_ConnectionTimeout") = 90
Application("Sweeps_CommandTimeout") = 300
End Sub

The following commands timeout commands ignore the settings in global.asa and timeout at 30 seconds.

in any page that runs a query...

        Session("ConnectString_HC") = "Provider=TDOLEDB;Data Source=TDPE;" & _
                                              "User ID=*****;Password=*****"

        DBConn.ConnectionTimeout = Application("Sweeps_ConnectionTimeout")
        DBConn.CommandTimeout = Application("Sweeps_CommandTimeout")

Can anyone tell me what I am doing wrong?



  <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: 23 Jun 2019