Re: Accessing Oracle 6(DOS) From VB/Q+E
Date: 13 Sep 93 16:04:07 GMT
Message-ID: <Sep.13.12.04.07.1993.1515_at_andromeda.rutgers.edu>
pranava_at_urd (Pranava) writes:
>I am doing this at home on my personal computer (no official
>duty) for my own purposes and I have run into the following
>problem :
>The platform I am using is as follows.
>486 DX2-50 8 MB RAM 245 MB disk.
>Oracle 6 for DOS.
>Windows 3.1
>Visual Basic 3. professional edition.
>When I run oracle from the DOS prompt, it does not like any
>extended memory managers for some reason. It loads and takes
>charge of the entire extended memory for its own purposes.
>Windows doesn't work if EMM386 or something is
>Not present. I have lost the installation giude on my way from
>India to here. I was using in only DOS mode in India.
>The Question :
>1. How do I make them Co-exist and How do I recognize the server
> from Visual Basic or Q+E Database editor ?
>Thanks in Advance.
This should be in the FAQ!!!!
Anyhow, you're correct, Oracle has its own memory management
software called SQLPME. The trick is to get SQLPME to
only grab the minimum RAM it needs to run the database only.
Go into the ORACLE6 directory and edit the file CONFIG.ORA.
Add a line beginning with DYNAMIC_MEMORY=
End this line with the amount of RAM oracle requires for just the database.
Try: DYNAMIC_MEMORY=4000
This will give 4 Megs of RAM to Oracle.
First off, Windows does not need EMM386.EXE to run. It does need the HIMEM.SYS extended memory manager which is compatible with Oracle's SQLPME. The other catch is that SQLPME is incompatible with Windows' Enhanced mode. You'll need to run Windows in Standard mode. THis is done by starting windows with the /S switch.
Windows will take the other 4 Megs of RAM not being used by Oracle This limits you a great deal because you only have 8 Meg of RAM. I'm not sure of the RAM requirements for VB 3.0 but whatever it is, it will have to be serviced by your "Real" RAM available since virtual memory is not supported under Windows Standard mode.
This is pretty tricky stuff (I can hear the UNIX guys snickering now!) It took me a while to be able to do this on my own machine.
Good luck.
Rich Holowczak holowcza_at_andromeda.rutgers.eduRutgers University
Ph.D. Computers and Information Systems Program
+---------------------------------------------------+---------------+ | For best results, squeeze .sig from the bottom | Ask about the | | and flatten as you go up. | car alarm FAQ | +---------------------------------------------------+---------------+Received on Mon Sep 13 1993 - 18:04:07 CEST