Archives of the TeradataForum

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

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

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?

Thanks,

Craig

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