Tuesday, August 9, 2005
Tip of the Day: Setting R:BASE/OTERRO Environment using UNC When you establish a universal naming convention (UNC) network connection for R:BASE database as System DSN defined with UNC, such as "\\FileServerName\SharedDirectoryName\dbname.rb1", you need to make sure that you have also set the path for R:BASE and OTERRO temporary SCRATCH files. SET SCRATCH sets the drive and directory location for temporary files created when sorting data. SET SCRATCH ON to store temporary sort files on the database drive and directory; SET SCRATCH OFF to store files on the current drive and directory; SET SCRATCH <path> provides the path to the location where temporary files are stored. The latest builds of R:BASE 7.1 for Windows (Build: 7.1.81.30720 or higher), R:BASE 7.5 for Windows (Build: 7.5.11.30720 or higher), R:BASE V-8 "Turbo" (Build: 8.0.9.30720 or higher), Oterro 3.1, and Oterro 3.5 include the enhancement to simply type "TMP" for SCRATCH option in RBEngine.CFG, RBEngine75.CFG, RBEngine8.CFG, OTERRO.CFG and OTERRO35.CFG files. Using the latest builds of R:BASE/OTERRO, you need to either update the line for "SCRATCH TMP" to automatically define the windows temporary environment or use "SCRATCH C:\TEMP", for example, in R:BASE/OTERRO configuration files. If you define the "SCRATCH C:\TEMP", make sure that you actually have the C:\TEMP directory. We suggest that you keep all configuration (*.CFG) file in Windows or WinNT directory. Updating the SCRATCH setting to TMP in the appropriate configuration files, R:BASE/OTERRO will use the user's TMP environment settings for SCRATCH files on startup. Use any text editor or R:BASE Editor 7.5 to edit the configuration file to read SCRATCH settings as follows: SCRATCH TMP This will help eliminate all issues related to accessing R:BASE database defined as System DSN using UNC option. Very Best R:egards, Razzak.
