Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

QUERY Timeout Problem

Status
Not open for further replies.

banda27

MIS
Mar 11, 2003
5
US
I have the below code in one of my ASP.NET pages. The ConnectionTimeout is not working I am getting an error after just 15 sec. Can some one suggest me the correct code.

********************************************************
Dim ConnectionString As String = ConfigurationSettings.AppSettings("ConnectionString")
Dim myConnection as New OdbcConnection(ConnectionString)
myConnection.ConnectionTimeout = 50000
Dim CommandText As String
CommandText = "select * from clst_rpt1 WHERE req_no=" & reqNo & " ORDER BY st_no desc,str_clu"

Dim myCommand As New OdbcDataAdapter(CommandText, myConnection)

Dim ds As New DataSet()
myCommand.Fill(ds)

DataGrid1.DataSource = ds
DataGrid1.DataBind()
************************************************************

Any help will be appreciated
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top