 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
VB Forum / Database Access / July 2007Really wiered problem. ALT+TAB closes database connection. Please help.
Hi all, I am facing a really weird problem and can't figure it out. I have my application that uses ADO to connect to SQL 2000 database. I have 3 parts to my application. The main app, then a .dll that does all database work like connections and queries that is called from the main app. And I also have an .ocx that does some controls on the main app. My problem is, when a user has 2 sessions of the app open, they will do a search for a transaction and while waiting, they will ALT+TAB to another app. When they ALT+TAB back to the app, they receive an error from my .ocx that does the transaction search that the connection to the database was closed and no work was done. If they don't ALT+TAB, and just stay in the app, all works fine. This also does not happened every time. It will happen maybe 1 out of 8 times a user would ALT+TAB. And it only does it on this search. Search for a transaction on average takes 30 sec. Please shine some light this annoying problem that I have been trying to figure out for past 2 months. I have even gone as far as the app sending me emails on every error it gets and this error for some reason is not trapped. I get all other error emails, but this one never comes through even though the user does have an error on their screen. Please help... bpolunin@hotmail.com's wild thoughts were released on Fri, 13 Jul 2007 21:05:21 -0000 bearing the following fruit: >Hi all, >I am facing a really weird problem and can't figure it out. [quoted text clipped - 24 lines] > >Please help... Can't say I've ever encountered this. My first thought would be it's a coding problem. Are you able to replicate the issue in a small test app? -- Jan Hyde https://mvp.support.microsoft.com/profile/Jan.Hyde No, I can't recreate the problem on my PC at all. But most of my users do experiance this problem. > bpolunin@hotmail.com's wild thoughts were released on Fri, > 13 Jul 2007 21:05:21 -0000 bearing the following fruit: [quoted text clipped - 37 lines] > > https://mvp.support.microsoft.com/profile/Jan.Hyde Also, If it was coding problem, wouldn't it be failing every time? It only happens 1 of of like 8 times for the user. > bpolunin@hotmail.com's wild thoughts were released on Fri, > 13 Jul 2007 21:05:21 -0000 bearing the following fruit: [quoted text clipped - 37 lines] > > https://mvp.support.microsoft.com/profile/Jan.Hyde bpolunin <bpolunin@discussions.microsoft.com>'s wild thoughts were released on Thu, 19 Jul 2007 16:28:02 -0700 bearing the following fruit: >Also, If it was coding problem, wouldn't it be failing every time? It only >happens 1 of of like 8 times for the user. Not necessarily. It could be down to how the user is doing something, or even the speed at which they do something, or it could be a result of something that went wrong somewhere else. >> bpolunin@hotmail.com's wild thoughts were released on Fri, >> 13 Jul 2007 21:05:21 -0000 bearing the following fruit: [quoted text clipped - 37 lines] >> >> https://mvp.support.microsoft.com/profile/Jan.Hyde -- Jan Hyde https://mvp.support.microsoft.com/profile/Jan.Hyde |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.