Auto Login in Forms [message #200316] |
Mon, 30 October 2006 06:00 |
jadoo83
Messages: 26 Registered: October 2006 Location: Mumbai
|
Junior Member |
|
|
Hi,
I want to eliminate the login prompt of Oracle forms 6i which we have to use for database connectivity for compiling and runninig the forms.
Is there any option because of which i'll be able to login in Forms 6i automatically.
Jitendra
|
|
|
|
|
|
|
|
Re: Auto Login in Forms [message #201827 is a reply to message #200481] |
Mon, 06 November 2006 23:23 |
jadoo83
Messages: 26 Registered: October 2006 Location: Mumbai
|
Junior Member |
|
|
Hi Bhujendra,Shahid and David,
I tried ur suggetions in following triggers viz.
NEW-FORM-INSTANCE
On-Logon Trigger
but it is not working means for compiling i have to any how login to database.
I went through the documentation of Form but i got optin for RUNTIME ENVIORNMENT, which is also not bypassing the login prompt for database.
I want similar thing as we can do in Oracle 9i by placing
"username/password@host"
in Target of shortcut.
Jitendra
|
|
|
Re: Auto Login in Forms [message #201828 is a reply to message #200316] |
Tue, 07 November 2006 00:12 |
kc1982
Messages: 13 Registered: October 2006
|
Junior Member |
|
|
Hi, do you mean that you want to run the Form Builder, in the meantime, automatically logon to the database, so you dont have to get the prompt message when you want to compile any form?
if yes, try this:
write the script below in any text editor and save it as .cmd (for example, form_builder.cmd)
SET ORACLE_SID=<your oracle SID>
REM SET NLS_DATE_FORMAT=DD/MM/YYYY
SET FORMS60_PATH= <your application source path>
SET REPORTS60_PATH= <your application source path>
SET UI_ICON= <your application source path>
cd <your application source path>
c:\oracle\ora6i\bin\ifbld60.exe userid=<username>/<password>@<connect_string>
Example
SET ORACLE_SID= clinicDB
REM SET NLS_DATE_FORMAT=DD/MM/YYYY
#SET FORMS60_PATH= C:\clinicDB\Source
#SET REPORTS60_PATH= C:\clinicDB\Source
#SET UI_ICON= C:\clinicDB\Source
cd C:\clinicDB\Source
c:\oracle\ora6i\bin\ifbld60.exe userid=admin/admin@clinicDB
Wish it helped!
Brennan 2006
[Updated on: Tue, 07 November 2006 00:14] Report message to a moderator
|
|
|