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.