Retrieve username and password from TDatabase component

okman

Delphi Developer

Sat, 14 Nov 1998 03:00:00 GMT

Retrieve username and password from TDatabase component

My program has a TDatabase component which is responsible for Transaction handling.
When I run program, a login prompt is automatically popup for username and password
because the active property of this TDatabase component is set to True. Can any one
tell me how can I retrieve the username and password from the TDatabase component ?
It is because I need the username and password to load a ReportSmith report without
the user to login the database again.

Thank you very much.

O.K.Man

Bryan Kelle

Delphi Developer

Sat, 14 Nov 1998 03:00:00 GMT

Re:Retrieve username and password from TDatabase component

Quote

okman wrote:

> My program has a TDatabase component which is responsible for Transaction handling.
> When I run program, a login prompt is automatically popup for username and password
> because the active property of this TDatabase component is set to True. Can any one
> tell me how can I retrieve the username and password from the TDatabase component ?
> It is because I need the username and password to load a ReportSmith report without
> the user to login the database again.

> Thank you very much.

> O.K.Man

TDatabase.Params.Values['USER NAME']
TDatabase.Params.Values['PASSWORD']

-Bryan

Bryan Kelle

Delphi Developer

Sat, 14 Nov 1998 03:00:00 GMT

Re:Retrieve username and password from TDatabase component

Quote

okman wrote:

> My program has a TDatabase component which is responsible for Transaction handling.
> When I run program, a login prompt is automatically popup for username and password
> because the active property of this TDatabase component is set to True. Can any one
> tell me how can I retrieve the username and password from the TDatabase component ?
> It is because I need the username and password to load a ReportSmith report without
> the user to login the database again.

> Thank you very much.

> O.K.Man

Ignore my first post. That won't work if you use the automatic login prompt. (I
just tried it). What I do is get the user name and password on my own, set the
TDatabase.Params and then set Connected to true without the login prompt. That
way you get the user name and password yourself, and can use it elsewhere. You
can also make a nicer, custom login screen that way.

Sorry about my mistake!

-Bryan

Other Threads

1. HELP: TDatabase.Parms won't accept USERNAME,PASSWORD

2. Setting username & password for TDataBase during runtim

3. Retrieving Username/Password (repost)

4. Help! Retrieving username+password from login

5. Howto Retrieve current username under NT40

6. HOWTO: Retrieve DomainName with Username

7. Retrieving UserNames and Using WNetAddConnection

8. how to retrieve the username of the user working on a remote computer (with known ip)

9. Retrieving current username while in a trigger

10. UserName & Password control with MS SQL7