DNSless connection problem

[ellenr]

I have a DNSless mysql database that keeps losing its connection. It was quite stable until the host server suffered a ddos attack that continued off and on for a couple of weeks. Now they tell me the server is having no problems, but I wonder. Is there any way for Access (2010) to detect the loss and programatically reconnect so the user doesn't have to close and reopen?

 

[llkhoutx]

You'll get an error on a read or write if you don't have a connection. Test for that error. When to make that test is problematic. I have a database with scores of bound forms and bound subforms. Adding such a test might be a horrendous task, unless I did in porgrammitically with a function on the Form OnError event..

 

[ellenr]

Even if I trap it, I don't know how to reconnect. Rerunning autoexec, where it connected in the first place, won't work.

 

[ellenr]

Another question: This same database runs just fine on my laptop, but cannot make the odbc connection at all on my desktop. Neither computer have the dns set up as database is dnsless. Both computers are 32 bit Win 7 computers, running Access 2010.

 

[llkhoutx]

Back to your first question. Use a form timer to try again, after a certain elapse time, a certain number of times.

Post you new question in a new post.

 

[ellenr]

A timer doesn't help a user in the middle of using the program. I tried just putting a button on the home page to run the autoexec again and it wouldn't work. Is there a way to make the connection more persistent?

 

[Trevor G]

Please don't double post it is against the forum rules.

http://www.access-programmers.co.uk/forums/showthread.php?t=279560