Getting Invalid user ID and Password before the applications starts

[maanasa]

Hi,

I'm getting Invaid User ID and Password before the application starts up. Any
idea as to why this error is coming. The application is built using oracle forms.

Please help me on this issue.


Regards,
Maanasa

[Dave44]

Hi,

I'm getting Invaid User ID and Password before the application starts up. Any
idea as to why this error is coming. The application is built using oracle forms.

Please help me on this issue.


Regards,
Maanasa

Well obviously the best we can do with this info is guess. so im gonna guess that somewhere during the startup of the app it is attempting to log in with a bad user\password combination. If you arent doing it yourself then it must be within the code somewhere in the app. either being retrieved from somewhere or hard coded in it.
thats my guess.

[Saii]

Does your application use windows user login or it has its own set of users.

[debasisdas]

You need to check for existance of the proper username / password combination in the application startup.

[maanasa]

I made changes to formsweb.cfg file.............. now the login screen is appearing without showing the error.............. but the database to which it is pointing is not coming......... in the sense, i'll have to give the database name once the login screen comes up............ Instead i want it to ask me user id and password only and the database text field should get populated by itself.......... Any help here......


Regards,
Maanasa

[debasisdas]

I made changes to formsweb.cfg file.............. now the login screen is appearing without showing the error.............. but the database to which it is pointing is not coming......... in the sense, i'll have to give the database name once the login screen comes up............ Instead i want it to ask me user id and password only and the database text field should get populated by itself.......

How the application decides which database to connect ?

[maanasa]

How the application decides which database to connect ?

Only one database exists. So any way the application's database should be pointing to the database. What changes do i make so that the login screen gets the database name by default, without me typing the database name.

Any changes to any of the server files need to be done? Please help.

Regards,
Maanasa

[maanasa]

Does your application use windows user login or it has its own set of users.

it has its own set of users. it doesnt use windows user id....

Regards,
Maanasa

[debasisdas]

if there is only one database then you can hardcode the database name and prompt only for the username and password.

[maanasa]

if there is only one database then you can hardcode the database name and prompt only for the username and password.

I cant hardcode in the code.. this has to be done in some web file... i do not know where exactly i'll have to do that...... any idea?

Thanks,
Maanasa

[bhopu]

there is a very easy reason for this that for saving the memory the oracle is locked.
the solution for this is:-
1- goto control panel.
2- then switch to classic view(if it is at category view).
3- then go to the administrative tools>services.
4- then click on standard at the bottom(if it is at extended).
5- then search it the oracle.
6- then right click on that. then click start or restart.
7- apply the 6th step for every oracle heading.
8. then restart your system and then run the oracle.

[subashsavji]

Hi,

I'm getting Invaid User ID and Password before the application starts up. Any
idea as to why this error is coming. The application is built using oracle forms.

Please help me on this issue.


Regards,
Maanasa

may you have not set the path.
c:\oracle\network\admin\tnsnzmes.ora\..
after comment you will get code having service name and other things like

Example2.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(COMMUNITY = spx.world)
(PROTOCOL = SPX)
(Service = Server_lsnr)
)
)
(CONNECT_DATA = (SID = ORCL)
)
)
here service name may be different for you what you given while creation of database oracle.
you copy this and paste it where you installed form
C:\forms60\network\admin\tnsnames.ora\
after comment you paste this above code...

may it will help you