Hi

I have an ElevateDB database which has been created programatically using Delphi, which can be viewed without problems from within programs created in Delphi. However when I try to view its contents using ElevateDB Manager, although I can create a new session pointing to the configuration set and log in, I get the correct users listed, but no databases or tables. I can however create new databases and tables using ElevateDB Manager in the same configuration path. I'm using the ANSI version of ElevateDB Manager and encrypted sessions, and have added the correct encryption password to the Manager's .INI file. Strings in the database tables are of collation 'ANSI_CI'. I'm creating a session pointing to the root config path. Is there something obvious I'm missing here?

Thanks in advance for any help


Jonathan Martin
Computing for Labour

Jonathan

All that's happening is you're not going far enough.


When you set things up in EDBManager you have to 1) create the session and then 2) create the databases within that session. The latter is little more than telling the session where the databases are, the session itself, when created, has no idea. If you look at you code where you're creating things you'll see you first create a session and then use that to create a database.

As an example in EDBManager I have 1 session which has a database pointing to the development data (DEV) , one which has a database pointing at the live data (LIVE)  and one which has databases pointing at both (WARNING). The latter is used when I want to use SQL to copy directly between DEV & LIVE since you have to be using the same session to do that. I can use DEV and LIVE simultaneously since they're separate and don't interfere with each other but I can't use WARNING and DEV together..

Roy Lambert [Team Elevate]

Roy Lambert wrote:

Jonathan

All that's happening is you're not going far enough.


When you set things up in EDBManager you have to 1) create the session and then 2) create the databases within that session. The latter is little more than telling the session where the databases are, the session itself, when created, has no idea. If you look at you code where you're creating things you'll see you first create a session and then use that to create a database.

As an example in EDBManager I have 1 session which has a database pointing to the development data (DEV) , one which has a database pointing at the live data (LIVE)  and one which has databases pointing at both (WARNING). The latter is used when I want to use SQL to copy directly between DEV & LIVE since you have to be using the same session to do that. I can use DEV and LIVE simultaneously since they're separate and don't interfere with each other but I can't use WARNING and DEV together..

Roy Lambert [Team Elevate]


Thanks Roy.

Its working now!


Jon

Jonathan,

<< I have an ElevateDB database which has been created programatically using
Delphi, which can be viewed without problems from within programs created in
Delphi. However when I try to view its contents using ElevateDB Manager,
although I can create a new session pointing to the configuration set and
log in, I get the correct users listed, but no databases or tables. I can
however create new databases and tables using ElevateDB Manager in the same
configuration path. >>

If you don't see any databases listed, then you're not using the same
configuration path as your application.  Do a quick search of your hard
drive for edbconfig.edbcfg files and make sure that you're not creating
configuration files in locations that you don't expect.  Then double-check
your application's TEDBEngine.ConfigPath setting and make sure that the
session in the EDB Manager is using the exact same path.  As long as both
are using the same config path, you should see the same databases in both.

Tim Young
Elevate Software
www.elevatesoft.com