Board index » delphi » Getting rid of database login prompt

Darrel Davis

Delphi Developer
Mon, 04 Aug 2003 08:30:43 GMT

Getting rid of database login prompt

I'm an old Delphi newbie.

I've created an OBDC DSN that connects to my remote database (PostgreSQL)
and
added this DSN as the DataBaseName of my TQuery object.  The
DSN has UID and PWD of the remote database but everytime I run
the app, I get a 'Database Login' dialog where I have to enter the
username and password. It connects and queries fine.

How do I set the username and password so that I don't get
the login dialog every time?

Any help appreciated.

-darrel

 
Esther Michae

Delphi Developer
Mon, 04 Aug 2003 09:25:34 GMT

Re:Getting rid of database login prompt


In article <96f83l02...@enews1.newsguy.com>, "Darrel Davis"

Quote
<dar...@davisware.net> wrote:
>I'm an old Delphi newbie.

>I've created an OBDC DSN that connects to my remote database (PostgreSQL)
>and
>added this DSN as the DataBaseName of my TQuery object.  The
>DSN has UID and PWD of the remote database but everytime I run
>the app, I get a 'Database Login' dialog where I have to enter the
>username and password. It connects and queries fine.

>How do I set the username and password so that I don't get
>the login dialog every time?

>Any help appreciated.

Add a TDatabase to your form.  Double click it.  A window should come out
(Database parameters?  can't remember its exact name) and you can fill in
the username and password parameters, also in there should be a check box
called Login Prompt, make sure this is OFF, then you shouldn't be hassled
at run time.  I think you might also need to hook your TQuery up to the
TDatabase, but I'm not certain.

HTH,
--
Esther Michaels
Please respond to newsgroup; I don't check my mail account

Other Threads

1. Getting rid of ReportSmith login prompt

2. Getting Rid of Login Prompt D5

3. Want to get rid of login prompt

4. Answer:Getting rid of the logon prompt

5. How to avoid Database Login Prompt using MS-Access Database

6. Getting around MS Access login prompt - how?

7. Getting rid of the login dialog box

8. dynamically created session and database : cannot avoid login prompt - fine with default session

9. avoid login prompt with ODBC databases

10. Howto Remove DataBase Login Prompt?????