Re: [Emerald] SQL Problems

Josh Hillman ( (no email) )
Sun, 25 Jul 1999 17:22:35 -0400

From: Ed Miller <emiller@del.net>
> I am trying to restart a SQL 6.5 server that bombed out a couple of
> weeks ago.
> I have it reloaded and it see the other SQL servers on the system.
> I started SQL Enterprise, Database/Object_Transfer and transferred
> Emerald
> from Beta (currently being used) to Alpha. Everything went fine, with the
> exception
> of passwords, which is usual.
> When I try to connect the Emerald dB, on Alpha, with Emerald 2.5.267
it
> shows no data.
> Shows zero users and a limit of 500. But if I connect to the dB with MS
> Query the info is in there.

Do you run into the same problems if you log into Emerald as "sa" instead of
a normal username? If you see things normally as "sa" then it sounds like a
permissions issue with the tables/columns.

Josh

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart