what would cause filling a dataset to hang my application?

[Darrel]

I have an app where I'm retrieving datasets and formatting them. This has
been working fine except in one intance, where the line that fills the
dataset is causing my application/aspnet to hang and eventually time out.

I can't figure out what this line would trigger the issue (the one marked
with asterisks):

===============================

Dim dsToReturn As DataSet
Dim strConnect As String
strConnect =
System.Configuration.ConfigurationSettings.AppSettings("DBConn")
Dim qryStr As String
Dim objConnect As New System.Data.OleDb.OleDbConnection(strConnect)
objConnect.Open()
qryStr = "SELECT startdate, enddate, boothNumber, locationDescription, city,
state, linkURL, additionalinfo, title, linkText FROM events WHERE startdate

>= DATEADD (day , -14, getdate()) ORDER BY startdate"

Dim objCommand As New System.Data.OleDb.OleDbCommand(qryStr, objConnect)
Dim objOleDbAdapter As New System.Data.OleDb.OleDbDataAdapter
objOleDbAdapter.SelectCommand = objCommand
objOleDbAdapter.Fill(dsToReturn, "records")

' *** this is where the app hangs:
objOleDbAdapter.Fill(dsToReturn, "records")

===============================

aside from the SQL query, this is the same code I'm using in many other
places in the application just fine. It's just this one instance that is
causing the problem.

Could it be my actual query? The query runs fine in enterprise manager.
Anyway to debug this?

-Darrel

 

[Darrel]

I can't figure out what this line would trigger the issue (the one marked

with asterisks):

Well, I figured it out. I was returning the function itself. So, that wasn't
the line it was hung on. Just a perpetual look.

Ugh. ;o)

-Darrel