Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Can't view databases / tables etc generated by code in ElevateDB manager |
Mon, Apr 22 2013 8:03 AM | Permanent Link |
Jonathan Martin Computing for Labour | 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 |
Mon, Apr 22 2013 8:42 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Mon, Apr 22 2013 9:01 AM | Permanent Link |
Jonathan Martin Computing for Labour | 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 |
Mon, Apr 22 2013 11:09 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |