Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2006-11-27
4
Medium Priority
?
440 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 2000 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
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…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

885 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