General information
Category:
The Mere Mortals .NET Framework
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only