Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
EDBMgr caught in endless loop |
Sun, Nov 13 2011 6:31 PM | Permanent Link |
David Cornelius Cornelius Concepts | I'm moving a database server from an old XP box to a nice new virtual server
hosted in the cloud. The new server is all setup and I was just checking some things on the old server (the XP box) when I opened a table that evidently has some problems. It started listing the records, but got only about half way (there's only about 10 records), then stopped and refreshed the grid and started listing them again. Same thing happened. Over and over. So I killed the process (with Task Manager), did something else for a while and restarted EDB hoping it would clear the connection and whatever was troubling it. When I restarted EDB Manager, it automatically connected to the database (I have a saved password) and reopened my last table (convenient). The problem was still there and immediately resumed the infinite loop of trying to display the records. Gah! I had to remote into the server and stop the database server, then start EDB Manager (which of course gave me a connection error) before I could break the cycle, restart the server, and get just the info I needed. It wasn't a deal-breaker, but if I didn't happen to have access to the server itself, I would've had to resort to writing a program or something else--not sure because the connection and the open table were saved settings with EDB Mgr and I couldn't find where that info is stored (no .INI or Registry settings?). David Cornelius Cornelius Concepts |
Sun, Nov 13 2011 6:58 PM | Permanent Link |
Raul Team Elevate | There is INI of the edbmanager but it is no longer saved with executable. Depending on the OS the location differs but generally it's under your user profile local settings. For win7 in my case it's in "C:\Users\<user account>\AppData\Local\Elevate Software\ElevateDB Manager (Unicode)" (this is one for unicode version of edbmgr). Inside the INI I believe the "current" state is saved in "Explorer State=" key Raul >>"David Cornelius" wrote: >>It wasn't a deal-breaker, but if I didn't happen to have access to the >>server itself, I would've had to resort to writing a program or something >>else--not sure because the connection and the open table were saved settings >>with EDB Mgr and I couldn't find where that info is stored (no .INI or >>Registry settings?). |
Sun, Nov 13 2011 7:08 PM | Permanent Link |
Fernando Dias Team Elevate | David,
The information about Session/Database/Tables opened in EDB Manager is in the "edbmgr.ini" file, under the [Manager] section. You can find it here: Win 7 : \Users\<UserName>\AppData\Local\Elevate Software\ElevateDB Manager Win Xp: \Documents and Settings\<UserName>\Local Settings\Application Data\Elevate Software\ElevateDB Manager Fernando Dias [Team Elevate] |
Sun, Nov 13 2011 9:15 PM | Permanent Link |
David Cornelius Cornelius Concepts | Ah! Perfect! Thank-you to both of you, Raul and Fernando.
I'm on Win7, so found it under my user's AppData folder as you mentioned. David Cornelius Cornelius Concepts |
Mon, Nov 14 2011 11:32 AM | Permanent Link |
Fernando Dias Team Elevate | David,
What cloud service are you using? I've been looking at clouds but so far all of them are looking pretty dark -- Fernando Dias [Team Elevate] |
Tue, Nov 15 2011 1:40 AM | Permanent Link |
David Cornelius Cornelius Concepts | Just started using a virtual Windows server at AccuWebHosting.com. It
looked good, was installed quickly, price was right, all standard features supported. My customer had their first day on the new machine with no problems. They're not hosting their web site there yet, so we just have an IP address and a hole in the firewall for EDB. David Cornelius Cornelius Concepts |
Tue, Nov 15 2011 6:24 AM | Permanent Link |
Adam Brett Orixa Systems | >> we just have an
>>IP address and a hole in the firewall for EDB. I have done exactly the same thing with Amazon, which was a bit fiddly to set up but is now very good. The cost of an Amazon "micro" server (which is big enough to easily run EDB) is $30 - $40 per month depending on access-levels. I would be curious to hear prices for other (reliable!) clouds. |
Wed, Nov 16 2011 3:02 AM | Permanent Link |
David Cornelius Cornelius Concepts | I tried out Amazon for myself a few months back. You're right, it is a
little more work to navigate their menus and security keys. But I think it's because they offer more than just virtual servers--they have virtual databases and plain (non-OS) storage areas and services that looked interesting, but are irrelevant to me. And even with their new micro server, AccuWebHosting still beats it at $23/month (if paid for annually up front). David Cornelius Cornelius Concepts |
Mon, Nov 21 2011 1:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | David,
<< I'm moving a database server from an old XP box to a nice new virtual server hosted in the cloud. The new server is all setup and I was just checking some things on the old server (the XP box) when I opened a table that evidently has some problems. It started listing the records, but got only about half way (there's only about 10 records), then stopped and refreshed the grid and started listing them again. Same thing happened. Over and over. >> Did you ever get a copy of the table to your local machine to try it there ? It sounds like something is funky with the connection, as opposed to the actual table. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Nov 24 2011 2:20 AM | Permanent Link |
David Cornelius Cornelius Concepts | That database was the main server database for this customer and I was
making daily backups of the entire database every night and downloading to my machine (automated script, of course). So yes, I had the table and it worked fine here. There were a couple of other tables that got corrupted within the previous two weeks and I told them their hard drive was on the way out and they needed to move to a new server fast. (I had actually recommended it some time back, but this really got their attention!) I had been able to do a table repair and get them going again. David Cornelius Cornelius Concepts |
This web page was last updated on Tuesday, May 14, 2024 at 07:14 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |