OraFAQ Forum: Forms » Bypass Log-in Screen in Forms 6i

Home » Developer & Programmer » Forms » Bypass Log-in Screen in Forms 6i

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

Bypass Log-in Screen in Forms 6i [message #161489]

Sun, 05 March 2006 08:53

proe
Messages: 4
Registered: March 2006

Junior Member

Hi

I have install forms builder 6i in my computer but i don't know how to connect the forms with the database. The database that i am using in oracle 8i. When i try to create a new form a login screen appears and ask for User-name, Password and Database to connect. Is there any default user name and password for login? If there isn't what i have to do to login?

Thank you

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #161637 is a reply to message #161489]

Mon, 06 March 2006 07:05

orausern
Messages: 826
Registered: December 2005

Senior Member

start your try with the user:scott (password is tiger).

you have also to give the connection string , as you must be aware.(it is the connect descriptor given in tnsnames.ora file)

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #161649 is a reply to message #161489]

Mon, 06 March 2006 08:12

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

Hi,
Do simply a one thing
Copy your oracle database tnsnames.ora And paste it to the tnsnames.ora of your forms builder 6i.

I writing here the path just follow them
\oracle\Home\network\ADMIN\Tnsnames.ora(copy this file)

This is the path of forms builder 6i tnsnames.ora.
\ORO6i\NET80\ADMIN\Tnsnames.ora(paste here)

Open tnsnames.ora in notepad.

Radha Sharma

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #161714 is a reply to message #161649]

Mon, 06 March 2006 18:28

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

If you have installed a new Oracle database then there is a default user "system/manager", use SQL*Plus to access the database using this userid, and create a new userid under which you will do your database application development.

David

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #161877 is a reply to message #161489]

Tue, 07 March 2006 11:40

proe
Messages: 4
Registered: March 2006

Junior Member

I have replace the file but still requires username and password when i try to connect to the database. I also try 'system/manager' which is the username and password for the database but still doesn't work.

Thank u for your replies. Is there anything else to do?

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162142 is a reply to message #161877]

Wed, 08 March 2006 23:29

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What is the error message you get when you try to connect to the database using SQL*Plus?

David

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162518 is a reply to message #162142]

Fri, 10 March 2006 14:11

proe
Messages: 4
Registered: March 2006

Junior Member

Hi

The error message that i get is "ORA-122033: TNS:unable to connect to destination"

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162551 is a reply to message #161489]

Sat, 11 March 2006 02:34

amolnk
Messages: 9
Registered: March 2006
Location: India

Junior Member

1. Make sure that the oracle database is up, listener is running (at cmd prompt : lsnrctl start), while trying to connect thru Forms, then providing user=scott, pwd=tiger,database=blank should suffice to connect

2. Else, create Local service name configuration for database using Oracle Net configuration assistant and for Forms do the same using Oracle Net8 Easy config, both service names should be same. Now, connect forms using user=scott, pwd=tiger, database= <new_service_name>. Forms should connect now.

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162577 is a reply to message #162518]

Sat, 11 March 2006 08:07

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

Hi Proe,
First tell me whether you replace Oracle database tnsnames.ora with your forms tnsnames.ora OR copy "Oracle database tnsnames.ora " and paste it to "forms tnsnames.ora" ..

Please check the Radha's message again.

Karan Shandilya.

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162581 is a reply to message #161489]

Sat, 11 March 2006 08:29

proe
Messages: 4
Registered: March 2006

Junior Member

Hi Karan

I have replace the files but still nothing. Is it matter that i am using oracle 8i and Forms 6i? My oracle user name is "system" and pass "manager", but they don't work on forms 6i.

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162660 is a reply to message #162581]

Sun, 12 March 2006 22:13

samit_gandhi
Messages: 226
Registered: July 2005
Location: Hong Kong

Senior Member

have u check whether ur listener is running or not?

if not running than start ur database

samit

Report message to a moderator

Re: Bypass Log-in Screen in Forms 6i [message #162873 is a reply to message #162581]

Mon, 13 March 2006 23:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

You may be having the "two tnsnames.ora file are different" problem. Please have a look at my answer at the bottom of http://www.orafaq.com/forum/t/60321/67467/.

David

Report message to a moderator

Previous Topic:	open report with parameter
Next Topic:	save button problem..(insert into.....)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 10:07:46 CST 2025