Link to home
Start Free TrialLog in
Avatar of alevin16
alevin16Flag for United States of America

asked on

Access with SQL backend on an Azure machine randomly drops connection

Hey Everyone

Well I got my employment squared away so I am back in the saddle!  I have an issue with a previous program I worked on.

I have an Access front end that connects to the data on the backend on an Azure server running SQL (I hope I am saying all this correctly.  I know very little about SQL and Azure).

For the most part the connection works great for everyone.  Every so often though a person will be using the program and they lose connection to the Azure server.  They have to exit the Access program (I have an Exit button) and then restart it.  

There does not seem to be a pattern.  It could be happening for one person but yet another person, at that same time, is having no issue at all.

I would love to see if anyone has an idea as to what could be going on, but I would also like to put into the Access program some sort of monitor that watches the connection (maybe in the Timer of the Main Form) every minute (or whatever is a good time frame).  I would love to have a red and green light on the Main Form that shows the connection status plus I would like it to add data to a table when the connection goes down.  This way I could start seeing if there is any pattern.

Thank You all and for anyone who answered my previous questions, I am really sorry I dropped out of existence, I lost my main job and was scurrying to make sure my family was ok.

Andy
Avatar of Gustav Brock
Gustav Brock
Flag of Denmark image

You have asked the same question before:

https://www.experts-exchange.com/questions/28552377/Azure-backend-of-database-timing-out.html

So, appearantly, that solution did not work?

/gustav
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
So, at any time, one should be prepared that the connection - though appearantly alive - is dormant, thus will fail, and you should catch that error and retry?

/gustav
yes, welcome to the Azure world!
Well, anything has advantages and disadvantages.

How often do these transients occur? And are they dependant on wether the application is idle or not? If so, Scott's method may have a positive impact.

/gustav
Avatar of alevin16

ASKER

Hello Everyone

Thank you so much for all the info.  I am going to see what I can do with this, and /gustav, I thought that original solution worked but it turned out it was just coincidence, I thought it was working but then a few weeks later it started again (damn that Azure, getting my hopes up :D)

I am going to try working on this today.  

Andy
OK.

No hurry, but could you be so kind to report back on your findings?

I have recently discussed a setup just like this with a client as it is a quite cheap method for hosting a true database in the cloud.

/gustav
Hello Everyone,

I absolutely will report back.  I am going to start trying these today and tomorrow.  I am going to try that always open form first to see if that has an effect.

Thank you all again!

Andy
Hello Everyone

So far so good.  I am going to give it a few more weeks to see if the non connecting issue appears again and then I will close this down.

Thanks
Andy
I am sorry I completely forgot I had it open.  Yes please do close it.  Thanks!
Andy
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
> I absolutely will report back.

Thanks Andy, please do.

/gustav