Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
More DataBases as in DBISAM...? |
Tue, Oct 16 2007 4:06 AM | Permanent Link |
Durumdara | Hi!
Sorry for "constant" asks but I'm in a big project and I wanna move fast to finishing it. So: in DBISAM philosophy the Server use one Config Database that containing all publishable databases, their users/paths/datas. In the EDB tutorial example I see only one DataBase using. So I wanna ask that how can I use more databases in the server? How can I register all databases, and where I can see them all (as in dbisam dbmgr)? How can I protect them? How to I get these infos quickly? And the most important question: where I can get the ODBC driver for access EDB databases? (I need to use it from web, from python). Thanks for your help: dd |
Tue, Oct 16 2007 10:14 AM | Permanent Link |
Durumdara | Durumdara <durumdara@gmail.com> wrote:
>>> So: in DBISAM philosophy the Server use one Config Database that containing all publishable databases, their users/paths/datas. So I wanna ask that how can I use more databases in the server? How can I register all databases, and where I can see them all (as in dbisam dbmgr)? >>> So, my main question is this: I have 3 applications. Every applications have local version (to test, develop it). And every of them have remote version (the published version). Every application have EDBConfig file (for local and remote using). This config file placed near to exe. But if I wanna publish these db-s in a DataBase server, I need to transfer all settings from the local EDbConfig files to global remote EDBConfig file. The "databases" are easily transfer with "create database xxx path yyy". But local users/roles I must transfer by hand! And possible the users or roles overlapped by others!!! And possible in one case I use another file extension in a database, and other in another. Or other setting are not same as in another application. So I don't understand how to I realize these things with one global EDBConfig file. This is hard, not user/developer friendly. Or I something understand wrong in the EBD's philosophy??? Is existing another way to registrate the DB-s I wanna publish with dbsrv? How? Dear Tim! Please help me a little to I understand the working method of the EDB! Please help me in the publishing my three databases! (For example: in IBExpert (a manager of FireBird/IB databases) I can register some databases with I wanna using/working. But these databases are not dependent from these registrations. In the edbmgr I can use only one EDBConfig file. But if I use this file for my ALL databases, I waste my disk place, and I enable security holes, because all database infos, users, etc. I stored in this file (and installed to everywhere), and not in separate config files (by app). But working with databases is better when I see them all in one place - like in IBExpert. This is different thing: the IBExpert is only registrate the databases - so it is user friendly). Thanks for your help: dd |
Tue, Oct 16 2007 2:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Durumdara,
<< So: in DBISAM philosophy the Server use one Config Database that containing all publishable databases, their users/paths/datas. In the EDB tutorial example I see only one DataBase using. >> EDB is the exact same design as DBISAM in terms of the server. << So I wanna ask that how can I use more databases in the server? >> CREATE DATABASE: http://www.elevatesoft.com/edb1sql_create_database.htm << How can I register all databases, and where I can see them all (as in dbisam dbmgr)? >> The EDB Manager allows you to perform the administration against the EDB Server without a separate admin utility or admin connection. << How can I protect them? How to I get these infos quickly? >> What do you mean by protect them ? Do you mean user security ? If so, then see here: http://www.elevatesoft.com/edb1sql_user_security.htm << And the most important question: where I can get the ODBC driver for access EDB databases? (I need to use it from web, from python). >> You can purchase it here: http://www.elevatesoft.com/scripts/order.dll?action=viewcatprod&product=edb You'll probably only need the EDB-DAC-STD product. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Oct 16 2007 2:53 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Durumdara,
<< Every applications have local version (to test, develop it). And every of them have remote version (the published version). Every application have EDBConfig file (for local and remote using). This config file placed near to exe. But if I wanna publish these db-s in a DataBase server, I need to transfer all settings from the local EDbConfig files to global remote EDBConfig file. The "databases" are easily transfer with "create database xxx path yyy". But local users/roles I must transfer by hand! And possible the users or roles overlapped by others!!! >> Just copy the configuration file and database files (catalog file and table files) over to the server machine, and then follow these instructions to modify the database paths as necessary: http://www.elevatesoft.com/edb_faqt_2.htm I would suspect that you aren't changing large portions of the database in this manner very often, and this type of operation would only be required a few times, if that. << And possible in one case I use another file extension in a database, and other in another. Or other setting are not same as in another application. >> File extension settings are not stored in the configuration file. The only thing stored in the configuration file is covered here in the manual: http://www.elevatesoft.com/edb1sql_configuration_database.htm << So I don't understand how to I realize these things with one global EDBConfig file. This is hard, not user/developer friendly. >> Frankly, I don't think you quite understand the EDB architecture yet, so it seems hard when it really isn't. The only difference between EDB and DBISAM is the use of the configuration file for local sessions in addition to the EDB Server. That's it. So, my question to you at this point is, how did you accomplish what you're trying to accomplish in DBISAM ? If you start from that point, you will find that nothing really changed in terms of remote sessions using the EDB Server. The only difference is that you use SQL instead of code for administering databases, users, etc. << (For example: in IBExpert (a manager of FireBird/IB databases) I can register some databases with I wanna using/working. But these databases are not dependent from these registrations. >> Neither are the databases in EDB. They are not dependent upon the contents of the configuration file. However, you do want to be careful with respect to how you modify users and/or roles, especially if they have been granted privileges in an existing database. The privileges are stored in the database catalog files, but the users/roles are stored in the configuration file. But, this is not unique to EDB, and any database server that uses external authentication can run into the same problem. MS SQL Server can have this issue, for example. << In the edbmgr I can use only one EDBConfig file. But if I use this file for my ALL databases, I waste my disk place, and I enable security holes, because all database infos, users, etc. I stored in this file (and installed to everywhere), and not in separate config files (by app). >> 1.06 will have the ability to use separate configuration files per local session: http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=16&msg=2723&page=1#msg2723 However, your issue is not that the EDB Manager can't use separate configuration files per session since you're using remote sessions for your published databases, correct ? What type of session are you using for your test sessions ? Are they local or remote ? -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Oct 17 2007 8:17 AM | Permanent Link |
Durumdara | "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:
>>> However, your issue is not that the EDB Manager can't use separate configuration files per session since you're using remote sessions for your published databases, correct ? What type of session are you using for your test sessions ? Are they local or remote ? >>> Hi! Sorry for Myst in my Brain, but I don't understand this... I write to you what I want to do, please tell me, how can I realize... Thanks for it! I have two projects. 1.) DVD auction house. 2.) Book store. These projects have two parts: Delphi + web (Python). The Delphi part is an application that used by the customer to administrating the web database (prices, products, etc.). These apps are installed in the client's machine somewhere. The Python (web) part installed in my webserver, and this is the published content. In this server I use DBISAM server to provide the infos to the client (Delphi part) and I use local session to get these datas for web (ODBC driver + Python). Scheme: The client -> Application -> DBISAM server -> local database (in server) <- ODBC <- Python <- Web. The Delphi parts are developed locally with local session using, with local databases. Later I developed them with remote session to check speed and test other things in it. So... In the developer machine I used INI files to provide database access infos. I simply change it (local/remote) as I need. In the server I used dbsrvmgr to registrate the databases, the database users, and to publish these databases for clients. THIS IS I WANT TO BUILD WITH EDB TOO. As I saw we bougth wrong product because this is not containing the ODBC driver. Ok, this is later needed, in the python section. But I finished with client app, so I want to set the application to remote mode. But before I do this I need to set up the server. This is the point where I "lost in configs". Because I copied the two databases (separate products!) to the server and I need to say the server to "these dbs I need to publish with these params..." as I do in DBISAM too. But I don't found a way to register these databases as in dbsrvmgr. Please help me a little: how can I do this thing? If you don't want to use this forum (because it is lama question) please write to me email address. Thanks for your help!!! dd |
Thu, Oct 18 2007 2:20 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Durumdara,
<< This is the point where I "lost in configs". Because I copied the two databases (separate products!) to the server and I need to say the server to "these dbs I need to publish with these params..." as I do in DBISAM too. But I don't found a way to register these databases as in dbsrvmgr. >> Just make sure that the EDB Manager is pointing to the same configuration file that the web application and EDB Server are both using (or use a remote session to connect to the EDB Server, which should be using the same configuration file as the web application), and then use the CREATE DATABASE statement in the SQL tab for the system-defined Configuration database to create the database. The steps to do so are outlined here: http://www.elevatesoft.com/edb1d7_loc_creating_tutorial_database.htm The general architecture of your application will look like this: Web App EDB Server | | ---- Config File ---- | | Database Definitions | Tables -- Tim Young Elevate Software www.elevatesoft.com |
Fri, Oct 19 2007 8:26 AM | Permanent Link |
Durumdara | Dear Tim!
Sorry Tim, but I need the answer to how can I register these TWO databases... >>>>>>>> "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: << This is the point where I "lost in configs". Because I copied the two databases (separate products!) to the server and I need to say the server to "these dbs I need to publish with these params..." as I do in DBISAM too. But I don't found a way to register these databases as in dbsrvmgr. >> Just make sure that the EDB Manager is pointing to the same configuration file that the web application and EDB Server are both using (or use a remote session to connect to the EDB Server, which should be using the same configuration file as the web application), and then use the CREATE DATABASE statement in the SQL tab for the system-defined Configuration database to create the database. The steps to do so are outlined here: http://www.elevatesoft.com/edb1d7_loc_creating_tutorial_database.htm The general architecture of your application will look like this: Web App EDB Server | | ---- Config File ---- | | Database Definitions | Tables >>>>>>>> So I understand it IF I HAVE ONE APPLICATION. But here is TWO (or later MORE) APPLICATIONS, TWO SEPARATED DATABASES. How to I say to EDBServer: "Hey guy, this database is here, in this directory - and you must publish it with these users/roles; and here is the another database in another way - and you must publish it with these (another) users/roles". As in DBISAM servermanager? In this program (dbsrvmgr) I can register the databases, I can link the users to the databases, I can check what databases are published, etc. This is what I searching in EDBServer. How can I do it? I cannot point to the ONE OF THE DATABASES, because I wanna point to all I want to publish! This is my LAMA question and this is what I want to do as soon as possible - in correct way. Thanks for your help, and sorry for disturbing! dd |
Fri, Oct 19 2007 2:51 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Durumdara,
<< So I understand it IF I HAVE ONE APPLICATION. But here is TWO (or later MORE) APPLICATIONS, TWO SEPARATED DATABASES. How to I say to EDBServer: "Hey guy, this database is here, in this directory - and you must publish it with these users/roles; and here is the another database in another way - and you must publish it with these (another) users/roles". >> The users and roles are not tied to a specific database, they are tied to the system-defined Configuration database, which is stored in the configuration file. Simply set up the users and roles in the Configuration database using the CREATE USER/ROLE statements, and then set up the privileges for the database(s) using the GRANT statements: http://www.elevatesoft.com/edb1sql_grant_privileges.htm http://www.elevatesoft.com/edb1sql_grant_roles.htm << In this program (dbsrvmgr) I can register the databases, I can link the users to the databases, I can check what databases are published, etc. >> In the EDB Manager, just connect to the EDB Server using a remote session and issue the appropriate SQL statements. As I stated before, there isn't a separate admin port and administration utility with EDB. You use the same connection as with other operations, and you simply need to have Administrative privileges (be granted the system-defined Administrators role) to execute the appropriate statements. << This is what I searching in EDBServer. How can I do it? I cannot point to the ONE OF THE DATABASES, because I wanna point to all I want to publish! >> In EDB you're going to need to set up the privileges for the various users/roles for each database. The privileges that are assigned for a given object or objects is stored in the database catalog for each database. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |