By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,757 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

adp connection

P: n/a
Hi,

I have an ADP which is compiled to ADE and used on workstations
in runtime mode and connectes to sql server 2000.
Sometimes the connection from the client to the server breaks, for example
when the server reboots, but in other cases too.
For some reason, when it happens, the clients can't work anymore and the
connection is not resumed. Since their access runs in runtime mode, they
don't
even have the "connection" option under the "file" menu, so the only way
to continue working is to exit the application and run it again.
Is there a way to restore broken connections automatically ? Or maybe
another way to solve this issue ?

Thanks!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Set up a procedure that saves the CurrentProject.BaseConnectionString
to a global variable when your application first opens. Then set up a
CommandBar button or some other button that is easily available to the
user and that runs the OpenConnection method of the CurrentProject.
E.g.:

CurrentProject.OpenConnection g_strBaseConnString

Where g_strBaseConnString holds the value of the
CurrentProject.BaseConnectionString when the project opened. This
assumes that this string is correct when the project first opens.

Then whenever the connection fails, the user clicks this button & the
db connection is re-established.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQDGJXoechKqOuFEgEQLi3QCfWXrUvkUX8JLR6FylytQwQg vghBgAnjVo
Cj2uCqIG47zod/fQF7PqbXn4
=5X9g
-----END PGP SIGNATURE-----
Marius Kaizerman wrote:
I have an ADP which is compiled to ADE and used on workstations
in runtime mode and connectes to sql server 2000.
Sometimes the connection from the client to the server breaks, for example
when the server reboots, but in other cases too.
For some reason, when it happens, the clients can't work anymore and the
connection is not resumed. Since their access runs in runtime mode, they
don't
even have the "connection" option under the "file" menu, so the only way
to continue working is to exit the application and run it again.
Is there a way to restore broken connections automatically ? Or maybe
another way to solve this issue ?


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.