[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Issues with application being minimized for 10 + minutes - Can errors occur upon maximization?

I have a VB.NET 2005 application using SQL Express.

I have ONE customer who has a 2.9gh P4 PC w/512K memory.  He maintains about 4 applications which includes PCMiler, Outlook 2003 and a couple of web pages with Internet Explorer 6.

If he is in mal or surfing for any length of time and then maximizes my application, it seems slow to refresh te maximization and after he performs 2-3 functions quickly where he pulls up a record and then updates it, he gets an error regarding a [field_?? not found].  This occurs on several different fields but the code for save works flawlessly otherwise.  And, besides, the field in question is not the first field in the update stored procedure or refresh of the text fields after update.

Is anyone aware of a problem with this or has experiences something like this??

Thanks!
Phil
0
TSFLLC
Asked:
TSFLLC
  • 2
  • 2
1 Solution
 
melmersCommented:
I can only think that it is a connection timeout thing. so on your code do you check the connection status every time before you make db operation ? can you reproduce the problem on your development machine ?
0
 
TSFLLCAuthor Commented:
melmers,

No I don't check the connection state.  I've never had an issue with connectivity....yet.

can you reproduce the problem on your development machine ?  >>  That's my #1 problem.  I can't seem to reproduce.  Yesterday while at their location and using my laptop I was able to reproduce it.  I was able to narrow it down but not exactly identify.

Brought their database home with me, restored it, began to make the same changes....and cannot reproduce the error once again.  But I have a strong idea about where the problem is and I think I need to rethink the setup of my code and make some modifications to it.

Thanks!
Phil
0
 
melmersCommented:
look at a timout in your connection when you use odbc or something else. do you use connection pooling ?
0
 
TSFLLCAuthor Commented:
Sorry for the delay melmers.  I made some minor code modifications to two Windows Forms and appear to have resolved the issue.  It appeared to be a conflict with a global variable setting where a dataset was getting stepped on by the previously generated dataset without a .dispose and/or .clear.

I appreciate the effort though.  I'm going to have this posting removed.

Thanks
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now