Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do you set the Command Timeout
Message
De
29/11/2004 13:05:15
Max Fillmore
Essential Skills, Inc.
Lenexa, Kansas, États-Unis
 
 
À
29/11/2004 01:27:40
Max Fillmore
Essential Skills, Inc.
Lenexa, Kansas, États-Unis
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
VB.NET 1.1
Database:
MS SQL Server
Divers
Thread ID:
00963696
Message ID:
00965463
Vues:
12
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...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform