Oracle Password Prompt

HCL Domino Domino Forum
1

Hi Pals,

In our web applications Domino 6.5.5 is connecting to Oracle 9i thru lsxlc and ODBC connectivity. (Let us asssume here the concurrent users are around 500 users)

In the applications all the field values fetched from Oracle using @dbcommand using ODBC connection(System DSN on the server machine) where username password and host string is supplied. It works fine…Bu t some times Suddenly a popup will appeat on the server machine display ODBC details (i.e) Server,Username&password. If we click ok on that popup it executes and also keeps on prompting for the username and password, so finally we areforced to re start the Domino server otherwise server will hang until we click ok on the oracle popup … which client will not accept for this. This is occuring offer

(Note while using lsxlc after connecting to oracle none of the place the connection is not closed … whether this will have any impact)

Pls give us some suggestions how to avoid this or is there any way to handle this …

thanks in advance …

regds,

Sathish.S

+91 9884674649

2

Subject: Oracle Password Prompt

Use odbcConnection.SilentMode = True

3

Subject: RE: Oracle Password Prompt

Hi,thanks for your resposne …

where should I use this line in notes.ini of server or any other place… As far as my assumption due to more no of concurrent users using the application at a time ,once it reaches the limit it is asking for the password prompt is there any other way to increase the concurrent users limit

regds,

Sathish.S

4

Subject: RE: Oracle Password Prompt

This would go in your code, before you attemp to open the connection. I’m not sure what you are referring to about a limit for concurrent users, is that on the Oracle server?