Home » Developer & Programmer » Forms » Running forms6i without runtime installed on client machine
Running forms6i without runtime installed on client machine [message #437706] Tue, 05 January 2010 13:22 Go to next message
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
Member
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(secure), 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
Re: Running forms6i without runtime installed on client machine [message #437780 is a reply to message #437706] Tue, 05 January 2010 23:58 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Does it work?

David
Re: Running forms6i without runtime installed on client machine [message #437793 is a reply to message #437780] Wed, 06 January 2010 00:53 Go to previous messageGo to next message
adnanBIH
Messages: 41
Registered: November 2007
Location: BiH, Sarajevo
Member
djmartin wrote on Wed, 06 January 2010 06:58
Does it work?

David

Yes David, it works, even on clients who doesn't have installed 6i runtime.... Smile
Now, i would like to know what professionals means about how much is secure running forms this way.
Also, is that recommended by Oracle, and does anyone has similar experiences...
Re: Running forms6i without runtime installed on client machine [message #438037 is a reply to message #437793] Wed, 06 January 2010 22:12 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If the machines are not connected to the Web then they will be secure. If they are connected to the web then raise security issues with the person managing your DNS access.

David
Previous Topic: Forms trigger override
Next Topic: DETECT DEFAULT LOCAL CLIENT PRINTER
Goto Forum:
  


Current Time: Fri Sep 20 12:31:22 CDT 2024