Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 443
  • Last Modified:

Direct ORacle Access component - how to turn off prompt for login

Hi All,
this may be a basic question but I am stumpted at the moment? - I have a simple application that uses a session , logon and query components from DOA or TOracle. I enter all the user, password, and database details but I still get prompted for a login when it connects to the Oracle database, all I need to do is click OK so I know all these details are correct.

DOes anyone know how to turn this prompt off

thanks

Dave
0
monitorwa
Asked:
monitorwa
  • 2
  • 2
1 Solution
 
kretzschmarCommented:
there may two possible propertys (don't have these components)

loginPrompt [true/false] -> show loginDialog yes/no
keepConnection [true/false] -> keep the connection alive, even if it is not accessed for a longer delay

additional could be a design mismatch

make sure that all query-/table-tablecomponents
are assigned to one session-component and/or databasecomponent

meikl ;-)

0
 
monitorwaAuthor Commented:
Hi meikl - you have helped me with questions before! - hopefully you can get me sorted with this one
There isnt a property like you mentioned however if I follow oraclelogon.options there are the following options as show in the help file

Declaration

type TLogonOption = (ldAuto, ldDatabase, ldDatabaseList, ldLogonHistory);

type TLogonOptions = set of TLogonOption;

property Options: TLogonOptions;

Description

The logon options allow you to control the following behavior of the logon dialog:

w      ldAuto       Causes the execute procedure to log on without showing a dialog if both username and password are specified for the Session.
w      ldConnectAs       Displays a dropdown list that allows you to connect as SYSDBA or SYSOPER. The list will only be visible when using Net8.
w      ldDatabase       Allows the user to enter a database name in the logon dialog.
w      ldDatabaseList       Displays a combo box list with database names. These database names are extracted from the SQL*Net / Net8 administration file tnsnames.ora, and can programmatically be accessed through the OracleAliasList. The size of the list is controlled by the AliasDropDownCount property.

w      ldLogonHistory       Displays a dropdown list with previously entered logon information, so that an end-user can quickly connect to a database. This logon history is stored in the hkey_current_user registry or in an ini-file. This option can further be controlled by the HistoryRegSection, HistoryIniFile, HistorySize and HistoryWithPassword properties.


problem is I cant seem to set them - any ideas?

thanks

Dave
0
 
monitorwaAuthor Commented:
Hi Meikl,
I have figured it out - well actually another guy came back in the office and hes a bit better at Delphi than me, sometimes you miss the obvious
there was an option under the logon component under "options" - idauto set this to true and that was it.

thanks again for your assistance

Dave
0
 
kretzschmarCommented:
glad you got it worked :-))

meikl ;-)
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now