Run Biblioscape in Client/Server setup with InterBase as the Backend Database

Products | Solutions | Support | Download | Order

Knowledge Base

Run Biblioscape in Client/Server setup with InterBase as the Backend Database - December 24, 2000

The following text only applies to Biblioscape before version 5.

Biblioscape support client/server setup with no extra cost by using the open source commercial quality SQL database InterBase. If people in your organization needs to access Biblioscape database from remote locations, running InterBase as the backend database will be the ideal solution.

1. Create a new InterBase database as shown in tip_001222.

2. Transfer the data of your Biblioscape default Paradox database into the database created in step 1 with datapump utility, as shown in tip_001223.

3. As a database administrator, you should create an account for each user who needs to access the database and assign the appropriate access privileges. First, log in to the database server. Click menu command "Server | User Security". Click button "New" to create a new user account. Second, you need to assign access privileges for the user. Click menu command "Tools | Interactive SQL...". Enter the following scripts and click menu command "Query | Execute". The script will assign access privileges of all tables in Biblioscape database to the user account "Guest".

CONNECT "c:\temp7\biblioscape4_ib.gdb" USER "SYSDBA" PASSWORD "masterkey";

grant all privileges on au_x to GUEST;
grant all privileges on bib to GUEST;
grant all privileges on bib_del to GUEST;
grant all privileges on bib_ID to GUEST;
grant all privileges on borrower to GUEST;
grant all privileges on cat_ID to GUEST;
grant all privileges on catalog to GUEST;
grant all privileges on chart to GUEST;
grant all privileges on chart_ID to GUEST;
grant all privileges on cir_ID to GUEST;
grant all privileges on circul to GUEST;
grant all privileges on fld_bib to GUEST;
grant all privileges on fld_ID to GUEST;
grant all privileges on folder to GUEST;
grant all privileges on inlib_ID to GUEST;
grant all privileges on interlib to GUEST;
grant all privileges on jn_x to GUEST;
grant all privileges on kw_n to GUEST;
grant all privileges on kw_x to GUEST;
grant all privileges on lender to GUEST;
grant all privileges on link_rec to GUEST;
grant all privileges on note to GUEST;
grant all privileges on note_ID to GUEST;
grant all privileges on ser_ID to GUEST;
grant all privileges on serial to GUEST;
grant all privileges on supplier to GUEST;
grant all privileges on task to GUEST;
grant all privileges on task_ID to GUEST;

4. Start Biblioscape, click menu command "File | Database | Configure Server Database...". Click button "New" to create the database access file. Select the database alias. In our example in tip_001223, it is called "biblioscape4_ib". Check the box "Login database without prompt". So you don't need to enter User Name and Password each time you open this database. Enter "User Name" and "Password" to access the database. Your database administrator should create one for you. The default one we used in tip_001223 is "SYSDBA" as user name and "masterkey" as password. Click OK button to close the Window.

5. Once the *.bss file is created. Go to Biblioscape menu command "File | Database | Open Database". Select the *.bss file you created in step 3. You can then use Biblioscape with InterBase as the backend RDBMS. The database could be hosted in another state, country, or even continent. But all the features of Biblioscape is available. If your users needs to access Biblioscape database remotely, but don't want to loose any features, this is the best solution. The other solution is to use the web based application BiblioWeb.