Solved

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

Posted on 2006-11-27
4
431 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses
Course of the Month9 days, 23 hours left to enroll

623 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