Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Problem with Local Session over a network - Database is empty
Thu, May 8 2014 6:24 PMPermanent Link

Barry

If I try to connect to my EDB v2.13 B2 Unicode database over a network using EDBMgr with a Local connection, I can connect to the session and open the database, but the database is empty. There are no tables, views, procedures etc.. I have confirmed all versions of EDBMgr are the same, namely v2.13 B2 unicode.

The database is encrypted and so is the catalog and I am using a non-default signature. The Customizations tab has customized Configuration Name, Catalog Name and file extensions.

All of this works fine if I connect using EDBMgr with a Remote connection OR if I use a local connection with EDBMgr on the same computer as the database.

I have the same problem if I try and access the database with a local connection from a virtual box. The application opens the database and there are no tables etc.. The application can access the database fine with a remote connection.

The local connection worked fine until a couple of weeks ago when I decided to move the database to a different directory and change the encryption password from the default value. After doing that I can't access the database with a local session unless the local session is physically on the same machine.

This is weird. I have obviously have forgotten to do something when I made changes to the database.
Can anyone offer any suggestions as to what I need to check?

TIA
Barry
Thu, May 8 2014 7:57 PMPermanent Link

Raul

Team Elevate Team Elevate

On 5/8/2014 6:24 PM, Barry wrote:
> If I try to connect to my EDB v2.13 B2 Unicode database over a network using EDBMgr with a Local connection, I can connect to the session and open the database, but the database is empty. There are no tables, views, procedures etc.. I have confirmed all versions of EDBMgr are the same, namely v2.13 B2 unicode.
>
> The database is encrypted and so is the catalog and I am using a non-default signature. The Customizations tab has customized Configuration Name, Catalog Name and file extensions.
>
> All of this works fine if I connect using EDBMgr with a Remote connection OR if I use a local connection with EDBMgr on the same computer as the database.
>
> I have the same problem if I try and access the database with a local connection from a virtual box. The application opens the database and there are no tables etc.. The application can access the database fine with a remote connection.
>
> The local connection worked fine until a couple of weeks ago when I decided to move the database to a different directory and change the encryption password from the default value. After doing that I can't access the database with a local session unless the local session is physically on the same machine.
>
> This is weird. I have obviously have forgotten to do something when I made changes to the database.
> Can anyone offer any suggestions as to what I need to check?

Where is the database located and is the database folder defined with
relative or absolute path (relative to catalogue).

My guess is that database cannot be found - for example if you had your
config in "c:\edbconfig" and database configured as "c:\edbdata" then
opening config over network (using for example
\\myserver\someshare\edbconfig) would fail to open  database (since it
looks for c:\edbdata instead of \\myserver\someshare\edbdata).

Obviously all if this woulr work with remote session (since edbsrvr is
local to machine) as well as local session on the machine (since all
paths make sense)

Make sure your database is specified with relative path (for example
"..\edbdata") that is accessible and makes sense when opening over network.


Raul
Fri, May 9 2014 2:14 AMPermanent Link

Barry

Raul,

Yes, that was the problem. Big thanks Smile

Barry
Image