Solved

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

Posted on 2006-11-27
4
414 Views
Last Modified: 2010-08-05
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
Comment
Question by:monitorwa
  • 2
  • 2
4 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 500 total points
ID: 18025815
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
 

Author Comment

by:monitorwa
ID: 18025984
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
 

Author Comment

by:monitorwa
ID: 18026177
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
 
LVL 27

Expert Comment

by:kretzschmar
ID: 18026527
glad you got it worked :-))

meikl ;-)
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This video discusses moving either the default database or any database to a new volume.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now