4 Replies Latest reply: Jun 29, 2013 6:12 AM by Kenforce RSS

    Running forms 6i on client without installed runtime !

    adnanBIH
      Dear proffesionals, what do you think about code below-we tried to enable our users to run applications developed in Forms 6i, without installed runtime on their machines. Is this solutions good, and why ? We installed forms6i runtime on the server, and make batch script (with code below), and make .exe file from that. Than we send link to users with locations of that .exe file? Is this way possible to run application through VPN ?
      Thanks in advance,
      Adnan

      Code:


      set ROOT_DIR=\\ip_address\
      set APLIK=\\ip_address\
      set ICONE=\\ip_address\

      set PROGRAM=Form.fmx
      set USER=username     
      set PASS=password
      set BAZA=database_name

      set path=%ROOT_DIR%;c:\dos;%PATH%
      set ORACLE_HOME=%ROOT_DIR%
      set path=%ORACLE_HOME%\BIN;%ROOT_DIR%;%PATH%;%ROOT_DIR%\BIN

      set FORMS60=%ORACLE_HOME%\FORMS60
      set FORMS60_PATH=%APLIK%

      set RW60=%ORACLE_HOME%\REPORT60
      set REPORTS60_PATH=%APLIK%

      set API=%ORACLE_HOME%\DBS
      set BROWSER60=%ORACLE_HOME%\BROWSER60
      set CA_GPREFS=%ORACLE_HOME%\
      set CA_UPREFS=%ORACLE_HOME%\
      set CORE40=%ORACLE_HOME%\CORE40
      set DE60=%ORACLE_HOME%\tools\common60
      set NET80=%ORACLE_HOME%\net80
      set ORA_NLS33=%ORACLE_HOME%\NLSRTL33\DATA
      set DEV2000_SCCONVERT=FALSE
      set DOC60=%ORACLE_HOME%\tools\doc60
      set GRAPHBMP60=%ORACLE_HOME%\graph60\gwiz_bmp
      set graphics60=%ORACLE_HOME%\graph60
      set graphogd60=%ORACLE_HOME%\graph60\gwiz_ogd
      set gsconnectdir=%ORACLE_HOME%\olap\ecf620
      set gsinstalldir=%ORACLE_HOME%\olap\ece620
      set gwizard60=%ORACLE_HOME%\graph60
      set mm60=%ORACLE_HOME%\tools\common60
      set nlsrtl33=%ORACLE_HOME%\nlsrtl33
      set ocl60=%ORACLE_HOME%\graph60
      set oin60=%ORACLE_HOME%\oin60
      set ora_nls33=%ORACLE_HOME%\nlsrtl33\data
      set oracle_jdk=%ORACLE_HOME%\jdk\
      set orainfonav_docpath=%ORACLE_HOME%\oin
      set otrace80=%ORACLE_HOME%\otrace80
      set plsql80=%ORACLE_HOME%\plsql80
      set pro80=%ORACLE_HOME%\pro80
      set qt_player=OMO
      set rdbms80=%ORACLE_HOME%\rdbms80
      set reports_builder=rwbld60.exe
      set reports_runtime=rwrun60.exe
      set reports60_classpath=%ORACLE_HOME%\jdk\lib\classes.zip;%ORACLE_HOME%\REPORT60\java\jars\myreports60.jar;%ORACLE_HOME%\REPORT60\java\jars\xmlparser.jar
      set reports60_express_ui=%ORACLE_HOME%\bin
      set reports60_jni_lib=%ORACLE_HOME%\jdk\bin\javai.dll
      set reports60_splash=TRUE
      set rw60=%ORACLE_HOME%\report60
      set shared_oracle_home=%ORACLE_HOME%
      set tk60=%ORACLE_HOME%\tools\common60
      set ui60=%ORACLE_HOME%\tools\common60
      set vgs60=%ORACLE_HOME%\tools\common60

      set UI_ICON=%ICONE%
      set NLS_LANG=CROATIAN_CROATIA.EE8MSWIN1250
      set NLS_DATE_FORMAT=DD.MM.RRRR
      set NLS_NUMERIC_CHARACTERS=,.

      start /separate /D%TEMP% ifrun60 module=%PROGRAM% userid=username/password@database

      echo off
      if not errorlevel 1 goto ok_2000
      CD %TEMP%
      start ifrun60 module=%PROGRAM% userid=%user%/%pass%@%baza%
      if not errorlevel 1 goto ok_9x
      goto error

      :ok_2000
      echo ---------------------
      echo Application started
      echo successfully
      echo at OS WIN2000...!
      echo ---------------------
      goto end

      :ok_9x
      cls
      echo ---------------------
      echo Application started
      echo successfully
      echo at OS WIN9x...!
      echo ---------------------
      goto end

      :error
      cls
      echo ---------------------
      echo There was some
      echo problems with starting
      echo this application...!
      echo ---------------------
      goto end

      :end
        • 1. Re: Running forms 6i on client without installed runtime !
          Andreas Weiden
          Is this way possible to run application through VPN ?
          Did you try it?

          I would guess it does not work, as far as i remember the runtime installation also includes dll's which are installed in the local machine system-directories. Additional you would need an Oracle Client (including Net80) which also needs some local installed components (as far as i remember).
          • 2. Re: Running forms 6i on client without installed runtime !
            adnanBIH
            Khmm, we only tried on machines that already had installed runtime 6i. But, i want to know, does anyone has similar experience running 6i forms this way....
            Also, I'd like to know does this way is recomended by Oracle itself.
            • 3. Re: Running forms 6i on client without installed runtime !
              CraigB
              In order to distribute a Forms 6i application to a client you really only have three (3) choices.
              1. Install the Forms Runtime on each PC (truely distributed application).
              2. Deploy the application using desktop virtualization (Citrix, etc). This option requires a Virtualization server.
              3. Web Deployed. (This requires the addition of an Application server and does require some type of installation on the client (the Oracle Jinitiator), but this can be automated with the Web Deployment.) Check out this link [Forms 6i Documenation|http://www.oracle.com/technology/documentation/6i_forms.html] and scroll to the bottom and view the "Oracle Forms Developer Release 6i: Deploying Forms Applications to the Web with Oracle Forms Server" document.

              Hope this helps.
              Craig...

              If a response is helpful or correct, please mark it accordingly
              • 4. Re: Running forms 6i on client without installed runtime !
                Kenforce

                Also, the entries made to the registry are important. These entries might not get added on the client machines through the above mentioned process.