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

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?).

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]

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

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]

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

>> 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.

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

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

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