home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 36 Tips
/
36-Tips.zip
/
osdalots.txt
< prev
next >
Wrap
Text File
|
1996-11-17
|
13KB
|
380 lines
OSDALOTS - SETTING UP LOTUS 1-2-3 IN AN OS/2 DOS SESSION
01/18/96
=======================================================================
Setting up Lotus 1-2-3 in an OS/2 DOS Session
=======================================================================
Please Read Entire Document for Full Explanation of Procedures
--------------------------------------------------------------
DESCRIPTION
Problems running Lotus 1-2-3 under OS/2
RESOLUTION
All versions of Lotus 1-2-3 running in OS/2 use expanded memory
specification (EMS) and look between C000 and DFFFF to find it. EMS
requires a 64 KB block of contiguous free memory in the address range
of 640 KB to 1 MB for its page frame. You could have an adapter
conflict.
Install and set up your Lotus 1-2-3 using the following setup
procedures. If Lotus does not start, see "OS/2 EMS Conflicts with DOS
Applications Running in a DOS Session" later in the document.
This document consists of the following sections:
* Setting Up Lotus 1-2-3
* Common Problems and Solutions
* OS/2 Expanded Memory (EMS) Conflicts with DOS Applications Running in
a DOS Session
* Reconfiguring the Memory Remapping on Various Systems
Setting Up Lotus 1-2-3
----------------------
Releases V2.0--V2.4
-------------------
1. Open the Templates folder on the Desktop.
2. Move the mouse pointer to the Program object; then press and hold
mouse button 2 and drag the Program object icon to the Desktop.
Release mouse button 2. The Settings notebook appears.
3. In the Path and File Name entry field, type the location of the
Lotus directory and executable file that starts the program. For
example, D:\123R23\123.EXE.
4. Select the Session tab.
5. Select DOS Full Screen as Session Type.
6. Select DOS Settings... .
7. Select EMS_MEMORY_LIMIT and set it to accommodate the
largest expected spreadsheet. The default is 2,048 (2 MG).
Note: V2.0--V2.2 recognize up to 4 MB of EMS. V2.3 and V2.4
recognize up to 12 MB.
8. Select MEMORY_INCLUDE_REGIONS and type C0000-CFFFF.
9. Select EMS_FRAME_LOCATION and change the value to C000.
10. Select MEMORY_EXCLUDE_REGIONS and type D0000-DFFFF.
11. Select Save.
12. Select the General tab and change the Title to the name you
want for the Desktop object; for example, Lotus 2.3.
13. Close the Settings notebook.
14. The Lotus 1-2-3 icon appears.
Release V3.1
------------
The Installation program checks that it is running in native DOS. Using
DOS Settings for an OS/2 DOS session, you can create a session that
returns a simulated DOS value to the Lotus INSTALL.EXE program.
The following steps must be performed to load Lotus in a Full Screen DOS
compatibility box under OS/2.
1. Using a text editor, create a 123.BAT file in the Lotus directory
and include the following statements:
* SET 123MEMSIZE=2048 or the desired amount of RAM (in KB)
to be allocated to the spreadsheet; 2048 is 2 MB. If you
have fairly large spreadsheets, set MEMSIZE to 4098 or
greater.
* 123 (or LOTUS). This begins the program.
2. Save and exit the file.
3. Open the Templates folder on the Desktop.
4. Move the mouse pointer to the Program object; then press and hold
mouse button 2 and drag the Program object icon to the Desktop.
Release mouse button 2. The Settings notebook appears.
5. In the Path and File Name entry field, type the location of the
123.BAT file to start the program. For example, D:\123R3\123.BAT.
6. Select the Session tab.
7. Select DOS Full Screen.
8. Select DOS Settings... .
9. Select DOS_FILES and set to at least 40.
10. Select DOS_VERSION.
11. Go to the Value box and scroll down to the last entry. Place the
cursor at the end of this entry and press Enter to start a new line.
12. Type the following lines in this sequence:
123.EXE,3,40,255
123DOS.EXE,3,00,255
LOTUS.EXE,3,40,255
INSTALL.EXE,3,40,255
TRANS.EXE,3,40,255
Note: If you do not want to run INSTALL.EXE or TRANS.EXE, omit the
last two lines.
13. Select Save to save the new settings.
14. Select EMS_MEMORY_LIMIT and set it to the same size as that in the
SET 123MEMSIZE statement above. If you do not change this, Lotus
sees only 2 MB of memory.
15. Select DPMI_MEMORY_LIMIT and set it to double the size
set in EMS_MEMORY_LIMIT.
16. Select DPMI_DOS_API.
17. Click to the right of Auto; then select Enable.
Note: Steps 1 and 14 through 16 are extremely important. If you do
not make MEMSIZE large enough, you might not have enough
memory to run Lotus after loading your spreadsheet.
18. Select MEMORY_INCLUDE_REGIONS and type C0000-CFFFF.
19. Select EMS_FRAME_LOCATION and change the value to C000.
20. Select MEMORY_EXCLUDE_REGIONS and type D0000-DFFFF.
21. Select Save.
22. Select the General tab and change the Title to the name you want
for the Desktop object; for example, Lotus 3.1.
23. Close the Settings notebook.
24. The Lotus 1-2-3 icon appears.
Release V3.4
------------
Installation
------------
If you get the error message,
"You cannot run this program in a DOS compatibility box.
You must run this program with DOS 3.3 or later."
try the following installation procedure:
1. Open the Settings notebook for the DOS Window or Full Screen
session in which you are installing Lotus.
2. Select the Session tab.
3. Select DOS Settings... and then DOS_VERSION.
4. On a new line, type INSTALL.EXE,5,00,255. This simulates DOS 5.0.
5. Select Save to save the new settings; then close the Settings
notebook.
6. Reinstall Lotus.
Setup
-----
Set up this version as described in "Release V3.1" above, except for
the DOS_VERSION settings. Type these lines instead:
123.EXE,3,40,255
LOTUS.EXE,3,40,255
INSTALL.EXE,3,40,255
TRANS.EXE,3,40,255
FONTGEN.EXE,3,40,255
INS.EXE,3,40,255
Common Problems and Solutions
-----------------------------
* Cannot read or write to drive A, and pressing Ctrl+Break at any time
causes the system to exit Lotus. Both cause a General Protection
Fault.
For systems with the original OS/2 2.0 code (3/30/92), install
Service Pak 2--XR06100.
* SYS2237 Error Message. Lotus 1-2-3 V3.1 assumes that all 486 chips
have a math coprocessor.
Edit the 123.BAT file and add -s (lowercase s) to the 123 line
(123 -s). Lotus 1-2-3 will no longer look for a math coprocessor.
* Cannot install Lotus 1-2-3. You receive the error message:
"You cannot run this program in a DOS compatibility box.
You must run this program with DOS 3.3 or later."
Try the following installation procedures:
Procedure 1:
------------
1. Open the Settings notebook for a DOS Window or Full Screen.
2. Select the Session tab.
3. Select DOS Settings... and then DOS_VERSION.
4. On a new line, type INSTALL.EXE,5,00,255. This simulates DOS 5.0.
5. Select Save to save the new settings; then close the Settings
notebook.
6. Reinstall Lotus.
Procedure 2:
------------
1. Start the system in native DOS.
2. Install Lotus from drive A, following the instructions that came
with the program.
Procedure 3:
------------
Start the system with a DOS diskette or create a Virtual Machine Boot
(VMB) from a DOS environment. IBM Technical Support has documentation
for a VMB.
OS/2 EMS Conflicts with DOS Applications Running in a DOS Session
-----------------------------------------------------------------
Many DOS applications, Terminate-and-Stay Resident programs (TSRs),
or loading device drivers high, use expanded memory specification (EMS)
when loading. Some examples of DOS applications are spreadsheets, word
processors, databases, desktop publishing, and computer aided design
(CAD) systems. Several problems can occur if EMS is not detected:
* You receive a SYS3176 error.
* The DOS session locks up when starting an application.
* When starting an application in a DOS session, a flash of text
pertaining to an adapter conflict appears and disappears so quickly,
you can barely see it. You then are returned to the OS/2 Desktop.
This problem usually is related to a Terminate-and-Stay-Resident
program (TSR).
A DOS session closes when it detects the TSR ending, so the session
cannot become resident. To load a TSR:
1. Open the Templates folder on the Desktop.
2. Move the mouse pointer to the Program object; then press and hold
mouse button 2 and drag the Program object icon to the Desktop.
Release mouse button 2. The Settings notebook appears.
3. Select the Program tab.
4. In the Path and File Name entry field, type an asterisk (*) if it
does not already exist.
5. In the Parameters field, type /K followed by the path and name of
the TSR; for example, /K C:\FT\FTTERM.BAT.
For more information, see Volume 2, page 200, of the IBM Redbooks.
* Very little expanded memory shows up in the application, no matter
what changes were made to the DOS Settings.
To configure EMS support for an OS/2 DOS session (VDM), a contiguous
64 KB block of RAM is used as the EMS Page Frame. This must be
available within the upper memory block (UMB) between 640 KB and 1 MB.
That address range should be between C0000 and CFFFF, which is
exactly 64 KB of memory.
All adapter cards whose ROM and RAM addresses are mapped within the
C0000--CFFFF range, should be remapped to the D0000--DFFFF range. The
most-common adapter cards are video, network, modem, and emulation.
Many IBM and OEM systems have their Token-Ring cards mapped to the
C0000--CFFFF region.
Reconfiguring the Memory Remapping on Various Systems
-----------------------------------------------------
IBM Systems
-----------
Some IBM systems, such as 56 SLC, 57 SLC, 56 SLC2, 57 SLC2, 76, 77, and
90, have a built-in utility program for creating a backup Reference
diskette. The diagnostic programs to reconfigure register addresses can
be run from the hard disk. Most of these systems have their video
adapters mapped to the C0000--CFFFF region.
To start the Utility Program from the hard disk:
1. Turn on the computer and allow the self-tests to finish.
2. Press Ctrl+Alt+Del.
3. Watch the cursor closely. When it moves to the top-right corner of
the screen, press Ctrl+Alt+Ins.
4. Go to "IBM Reference Diskette Instructions" below.
IBM ValuePoint
--------------
These systems have their video addresses mapped to the A0000--AFFFF
range. They also have to start the program from the hard disk.
Other IBM PS/2 Micro Channel Systems
------------------------------------
A Reference Diskette is provided with each system. Start the system
with the diskette in drive A; then see the next topic.
IBM Reference Diskette Instructions
-----------------------------------
1. When the IBM logo appears, press Enter.
2. Select Set Configuration.
3. Select Change Configuration.
4. Select the slot and location of the adapter that is mapped to the
C0000--CFFFF range.
5. Press F6 to toggle to a free D0000--DFFFF memory range address.
6. Press F10 to save the configuration.
7. Restart the system.
The goal is to free the C0000--CFFFF address by moving adapter ROM and
RAM addresses to the D0000--DFFFF range.
EISA and ISA Bus Architecture Systems
-------------------------------------
Many of these systems have a built-in Diagnostics Setup and
Configuration file. After startup, the screen displays a sequence of
keys that you press to get to the setup. Some systems allow only
viewing; others allow viewing and reconfiguring. Many adapters can be
reconfigured only by resetting switches on the adapter. Refer to the
documentation that came with the adapter, or contact your vendor for
additional information.
______________________________________________________________________
IBM disclaims all warranties, whether express or implied, including
without limitation, warranties of fitness and merchantability with
respect to the information in this document. By furnishing this
document, IBM grants no licenses to any related patents or copyrights.
Copyright (c) 1994, 1995 IBM Corporation. Any trademarks and product
or brand names referenced in this document are the property of their
respective owners. Consult your product manuals for complete trademark
information.