OraFAQ Forum: Forms » Auto Login in Forms

Home » Developer & Programmer » Forms » Auto Login in Forms

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Auto Login in Forms [message #200332 is a reply to message #200316]

Mon, 30 October 2006 06:49

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

Report message to a moderator

Re: Auto Login in Forms [message #200337 is a reply to message #200316]

Mon, 30 October 2006 06:59

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

Report message to a moderator

Re: Auto Login in Forms [message #200421 is a reply to message #200337]

Mon, 30 October 2006 19:37

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: Auto Login in Forms [message #200471 is a reply to message #200421]

Tue, 31 October 2006 01:14

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

Report message to a moderator

Re: Auto Login in Forms [message #200481 is a reply to message #200471]

Tue, 31 October 2006 01:40

Littlefoot
Messages: 21809
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.

Report message to a moderator

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

Report message to a moderator

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

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 14 09:59:59 CDT 2024