I am provided the login user and password to the session, but whenever I open a Database
component it prompts for the login credentials.
How can I log the user into the database without prompting them with this dialog. I do not
have DBLogDlg in my uses.

     with self.F_EDBSession do
     begin
       //  RemoteAddress := '192.168.15.150';
       RemoteAddress   := objINI.ReadString(sDefaultDB,'RemoteAddress','');
       if (lowercase(sLocalOrRemote) = 'remote') then
         SessionType   := stRemote
       else
         SessionType   := stLocal;
       LoginUser       := objINI.ReadString(sDefaultDB,'User','');
       LoginPassword   := objINI.ReadString(sDefaultDB,'Extra','');
       // reading in as string so it can be converted using trystrtoint
       sWork           := objINI.ReadString(sDefaultDB,'RemotePort','');
       trystrtoint(sWork,nWork);
       RemotePort      := nWork;
       AutoSessionName := True;
       Open;
     end;

     self.F_EDBDatabase.Open;  // << - shows login dialog

Daniel,

<< I am provided the login user and password to the session, but whenever I
open a Database component it prompts for the login credentials. How can I
log the user into the database without prompting them with this dialog. I do
not
have DBLogDlg in my uses. >>

You need to make sure that you assign the TEDBSession's SessionName to the
TEDBDatabase and other TEDB* components, or else they won't use the correct
session for access.

--
Tim Young
Elevate Software
www.elevatesoft.com

Daniel,

Further information: setting the AutoSessionName property to True will only
assign the TEDBSession's SessionName property to all of the other components
on the same owning form or data module.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim, thank you for your replies.

Adding the sessionname fixed the issues: with empty config, with login dialog, and with
the SQL.

Reading the PDF, edb2r2007.pdf, it looks as though sessionname is for threading (page 75).
Though I am not writing a multi-threaded application in this case, why would I want more
than one TEDBSession in an application?

Again, thank you for your FAST replies - very impressive.

Daniel,

<< Reading the PDF, edb2r2007.pdf, it looks as though sessionname is for
threading (page 75). Though I am not writing a multi-threaded application in
this case, why would I want more than one TEDBSession in an application? >>

The SessionName is required for hooking up the various TEDB* components so
that they all use the correct session.  Every application has at least one
session, and multiple session components can be used in both single-threaded
and multi-threaded applications.  For example, the ElevateDB Manager uses
multiple sessions even though it is single-threaded.

<< Again, thank you for your FAST replies - very impressive. >>

You're quite welcome.

--
Tim Young
Elevate Software
www.elevatesoft.com