Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do you set the Command Timeout
Message
From
02/12/2004 11:29:46
Max Fillmore
Essential Skills, Inc.
Lenexa, Kansas, United States
 
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
VB.NET 1.1
Database:
MS SQL Server
Miscellaneous
Thread ID:
00963696
Message ID:
00966425
Views:
8
Kevin,

I found the compile problem. I didn't have a CreateDataAccessObject() function in the business object. I was sure I put it in there but I guess it didn't get saved.

My (your) version of FillDataSet() now runs. It still times out however! Both the Connection and the Command have timeouts set to 180 seconds as evidenced by debug.writeline() calls in my FillDataSet() function. However, the query times out after 43 seconds everytime. If I change the CommandTimeout and the ConnectionTimeout to 20 seconds each, the query still times out after 43 seconds.

I'm using a local SQL-Server 2000. SQL Query Analyzer runs "Select * from MyView" in 30 seconds which is the same code my bizobj is running to populate the dataset. Is there some other timeout besides ConnectionTimeout and CommandTimeout that could be limiting the query when run from VB.NET?

Thanks,
Max...
Previous
Reply
Map
View

Click here to load this message in the networking platform