Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 11 to 15 of 15 total |
Code causes EDB server to stop |
Fri, Oct 10 2014 5:16 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Terry
Nice to see you're still around. >EDB will NOT send a ping if you already have something running that uses the >communication layer to the server. Try creating an event for the >OnRemoteTimeout of your remote session and set StayConnected:=True; in the >event code. This will prevent it from timing out during a really long >query. Interesting and useful. Roy Lambert |
Fri, Oct 10 2014 7:29 PM | Permanent Link |
Terry Swiers | Hi Adam,
> This is a really useful tip, particularly if you are running slow > PROCEDURES (like transferring files up to a server). I don't believe that transferring files to the server should be an issue as it's active communication between your app and the server. > In that case (i.e. remote server crashing part-way through a query / > procedure) would the above method result in an infinite connection or does > some other event then get triggered? If the server crashes part way through the process, you will get a lost connection error from EDB. --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com --------------------------------------- |
Fri, Oct 10 2014 7:32 PM | Permanent Link |
Terry Swiers | Hi Adam,
> This is a really useful tip, particularly if you are running slow > PROCEDURES (like transferring files up to a server). I don't believe that transferring files to the server should be an issue as it's active communication between your app and the server. The situation that forced me to really look hard into it was restructuring of large tables on a slow server. I may be incorrect in my assumption, but it appears that EDB has to wait for the OS to make the table "old" copies and doesn't send status or progress back to the app while this is occurring. This was causing my app to fail during some large database updates. > In that case (i.e. remote server crashing part-way through a query / > procedure) would the above method result in an infinite connection or does > some other event then get triggered? If the server crashes part way through the process, you will get a lost connection error from EDB. --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com --------------------------------------- |
Fri, Oct 10 2014 7:32 PM | Permanent Link |
Terry Swiers | Hi Roy,
> Nice to see you're still around. Definitely still here. Just been so busy with my own stuff that I haven't had much time to spend here. > Interesting and useful. Glad I could help. I'm usually boring and useless. --------------------------------------- Terry Swiers Millennium Software, Inc. http://www.1000years.com http://www.atrex.com --------------------------------------- |
Sat, Oct 11 2014 9:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Terry
>Glad I could help. I'm usually boring and useless. Can't comment about the boring since we have never actually spoken but useless - no. I use (slightly modified versions of) you applock component. That's great. Roy |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Thursday, May 23, 2024 at 07:54 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |