If you are using both Applixware version 4.4.1 (or later) and ADABAS D as
delivered on Linux Office 99, you do not need to do anything.
- First, please ensure that Applixware and the RDBMS run on the same
server. The remote SQL server, however, still has to be started. Start the
remote SQL server using the xcontrol program or enter
x_server start
- You will need an ODBC driver to be run as a shared library under Linux.
It is possible to load the driver using the iODBC driver manager. Save the
library in
/opt/applix/axdata/acshlib/lib
(if not already
there). For ADABAS D, the library can be compiled using the following
commands:
export DBROOT=/usr/lib/adabas
cd $DBROOT/lib/ ;
gcc -shared -Wl,-Bsymbolic -Wl,-whole-archive \
odbclib.a libsqlptc.a libsqlrte.a \
-lc -lm -lncurses -o libadabas.so ;
mv libadabas.so /opt/applix/axdata/axshlib/lib ;
- You have to tell Applixware the path to find the ODBC driver.
Check and add the following entry to the file
/opt/applix/axdata/axnet.cnf:
libFor elfodbc /opt/applix/axdata/axshlib/lib
and for the right environment
setenvFor elfodbc /opt/applix/axdata/axshlib
-
Check / add in the /etc/services file the following entries:
axnet 5492/tcp # Applix anywhere
sql30 7200/tcp # adabasd remote sql
- Become root and start the axnet server process. If ADABAS D has
to be accessed, the DBROOT variable has to be valid:
export DBROOT=/usr/lib/adabas
/opt/applix/axdata/axnet
or use the initialization script /sbin/init.d/axnet
- Check if the applixware client is able to connect to the
database server (if not running on the same server). Press F8
and start the following macro:
axnet_test@ remote_host
- The user needs the file ~/.odbc.ini in his home directory.
The data source has to be entered in this file.
[ODBC Data sources]
adabas=adabas database
[adabas]
ServerDB = MYDB
Server = localhost
Driver=/opt/applix/axdata/axshlib/lib/libadabas.so
[ODBC]
Trace=0
TraceFile=odbctrace.out
InstallDir=/opt/applix/axdata/axshlib
Here [ODBC Data Sources] adabas=your_description defines the
ODBC data source (here: adabas) which will be further specified
after [adabas].
- ADABAS D needs at least one entry in
/var/spool/sql/config/odbc.ini:
[adabas]
ServerDB = MYDB
Server = localhost
If the entry Server = localhost is replaced by
ServerNode=fully.qualified.domain
remote access to the data source is possible.
- Now it is possible to run and access the database. Start Applix Data
and choose an ODBC data source. Click 'Query' and then 'Choose Server'. Go to
'ODBC', click it and then select 'Browse'. You will see a dialog giving you a
choice of database servers. Choose "Adabas" (adabas database) and click
'OK' twice. You are about to be connected to the database; you still need
to enter your login and your password (in the ADABAS D demo version both
features are just demos).
- Now you are in the right place to choose tables by going to 'Query'.
Choose among 'Available Tables' the ones you need and copy them by clicking
on the right arrow to the 'Tables to Query' window. If you select more than
one table and you want to view them, click on the 'conditions' button and
select the 'join' condition. It is possible to display the tables by
clicking "Query -> Query".

See also:

Keywords: APPLIX, OFFICE, DATABASE, ODBC, ADABAS, SQL

Mainpage
Searchform
History
Versions
Categories
Contents
Deutsch
SDB-applix_data, Copyright SuSE GmbH, Nuremberg, Germany
- Version: 27. Oct 1998
SuSE GmbH - Last generated: 07. Oct 1999 16:31:25
by maddin
with sdb_gen 1.00.0