Solved

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

Posted on 2006-11-27
4
427 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say 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

Suggested Solutions

Title # Comments Views Activity
find a node in VST 2 93
how to send memory stream from ics Client To ics server ? 11 211
Twebbrowser add css to the header 3 54
scroll down TListBox component in Delphi 1 44
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

751 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