CRYSTAL REPORTS FOR R:BASE
INSTALLATION TIPS
Overview
========
After you install Crystal Reports for R:BASE, you may find
that you are unable to connect to your databases. The
following steps may correct installation problems and allow
you to connect to your databases.
QEX.INI
=======
During installation, you may receive the message "cannot
copy QEX.INI to \WINDOWS sub-directory". This message should
be ignored.
Installing the Dynamic Link Libraries
=====================================
Crystal Reports for R:BASE uses several Dynamic Link
Libraries (.DLL files) during operation. In a standard
installation, the RBASE.DLL, RBASE45.DLL, RBSETUP.DLL,
ODBCINST.DLL and the ODBC.DLL are copied to the
C:\WINDOWS\SYSTEM sub-directory. If these files are not
present in the \WINDOWS\SYSTEM sub-directory, copy them from
the drive and sub-directory where Crystal Reports for R:BASE
is installed.
Installing the ODBCINST.INI and ODBC.INI Files
==============================================
Crystal Reports for R:BASE uses the ODBC.INI file to
determine where R:BASE databases are located (drive and sub-
directory) and which ODBC driver to use with the database
(R:BASE 4.0 or R:BASE 4.5). The ODBCINST.INI file tells
Crystal Reports for R:BASE where the Dynamic Link Libraries
are installed. In a standard installation, these files are
copied to the C:\WINDOWS sub-directory. If these files are
not present in the \WINDOWS sub-directory, copy them from
the drive and sub-directory where Crystal Reports for R:BASE
is installed.
Editing the ODBCINST.INI File
=============================
The ODBCINST.INI must show the correct drive and path for
the .DLL files. The standard ODBCINST.INI shows the path
for the R:BASE drivers as:
[R:BASE]
Driver=c:\windows\system\RBASE.DLL
Setup=c:\windows\system\RBSETUP.DLL
[R:BASE45]
Driver=c:\windows\system\RBASE45.DLL
Setup=c:\windows\system\RBSETUP.DLL
[ODBC Drivers]
R:BASE=Installed
R:BASE45=Installed
If the drive and path on your system is different, the
ODBCINST.INI must be edited to relect this. For instance,
if Windows is installed on your D: drive in a \WIN31 sub-
directory, then the ODBCINST.INI should read:
[R:BASE]
Driver=d:\win31\system\RBASE.DLL
Setup=d:\win31\system\RBSETUP.DLL
[R:BASE45]
Driver=d:\win31\system\RBASE45.DLL
Setup=d:\win31\system\RBSETUP.DLL
Editing the ODBC.INI File
=============================
The ODBC.INI must show the correct drive and path for your
R:BASE databases. This file should only be edited using the
Microsoft ODBC Administration Utility. The utility is not
installed during the standard Crystal Reports installation.
To install this utility:
1) Select the Crystal Reports Group (this places the
administrator icon with the other Crystal icons)
2) Select File|New|Program Item from the Windows
Program Manager.
3) Complete the Program Item Properties as follows:
Description: ODBC Administrator
Command Line: ODBCADM.EXE
Working Directory: C:\CRW (the drive and sub-
directory where Crystal Reports is installed)
Adding Databases
================
After installing the Microsoft ODBC Administration Utility,
return to the Windows Program Manager and select the ODBC
Administration from the Crystal Report Group. If you want
to add an R:BASE 4.0 database, highlight R:BASE in the
Installed Drivers dialog box. If you want to add an R:BASE
4.5 database, then highlight R:BASE 4.5.
Select Add New Name. The Microrim R:BASE Driver Setup
dialog box appears. Enter the drive\directory\database name
with no extension. The Description is optional. Choose OK
and the database is added. You may now start Crystal
Reports for R:BASE and access this database.
Please refer to Configuring R:BASE and ODBC in the Crystal
Reports for R:BASE User's Manual (page 1-4) for more
information regarding using this utility.
R:BASE for DOS and R:BASE 4.5 Considerations
============================================
Abnormal behavior when executing R:BASE for DOS (version 2.11)
or R:BASE 4.5 may result from conflicting message files. To
correct this problem:
1. Delete COMMON.MSG, RBASE1.MSG AND RBASE2.MSG from
the \WINDOWS sub-directory.
2. Set your DOS path so that the sub-directory where
your R:BASE files reside precedes your Crystal
Reports sub-directory. Your Crystal Reports sub-
directory must be on your path so the the .DLL
files can access the .MSG files.