Home » Developer & Programmer » Forms » Auto Login in Forms
Auto Login in Forms [message #200316] Mon, 30 October 2006 06:00 Go to next message
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 #200332 is a reply to message #200316] Mon, 30 October 2006 06:49 Go to previous messageGo to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Hi Jitendra,

You can use
logon('USERNAME','PASSWORD'||'@'||'CONNECTSTRING'); 

in NEW-FORM-INSTANCE Trigger at Form level.
With the help of above you can automatically connects to your form.

Eg: logon('scott','tiger'||'@'||'scott'); 

Thanks
Bhujendra



Re: Auto Login in Forms [message #200337 is a reply to message #200316] Mon, 30 October 2006 06:59 Go to previous messageGo to next message
kbhujendra@rediffmail.com
Messages: 26
Registered: June 2006
Location: Hyderabad,India
Junior Member

Hi,
Quote:
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

It is not possible as of my knowledge.

Bhujendra
Re: Auto Login in Forms [message #200421 is a reply to message #200337] Mon, 30 October 2006 19:37 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Open the Form documentation, find the command for invoking the form builder, there is an example of how to add the userid and password to the command line, add this extra information to the shortcut you are using to start your Form Builder session.

David
Re: Auto Login in Forms [message #200471 is a reply to message #200421] Tue, 31 October 2006 01:14 Go to previous messageGo to next message
shahidmughal
Messages: 91
Registered: January 2006
Location: Faisalabad Pakistan
Member

hi

------------------
logon('USERNAME','PASSWORD'||'@'||'CONNECTSTRING');

Eg: logon('scott','tiger'||'@'||'scott');
--------------------

better to use this syntax in

On-Logon Trigger

regards

Muhammad Shahid Mughal
Re: Auto Login in Forms [message #200481 is a reply to message #200471] Tue, 31 October 2006 01:40 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK, but for security reasons (passwords ARE to be changed now and then, aren't they?), this might get inappropriate if you'll have to modify all your forms and enter a new password into all ON-LOGON triggers.
Re: Auto Login in Forms [message #201827 is a reply to message #200481] Mon, 06 November 2006 23:23 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: Querying data in the detail block
Next Topic: Fonts Change When Running
Goto Forum:
  


Current Time: Sat Dec 03 12:26:37 CST 2016

Total time taken to generate the page: 0.09613 seconds