Information générale
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement