Cannot really follow what you are doing, but ....
the Tdatabase component has a property called prompt for password ... or
something like that. Anyway, that property does just that. Set it to false
and supply the password params and you should be right (then open the
connection). If you do not have a database component on the app then the
Session object (I think) holds the default database which I imagine needs to
be programatically set prior to opening the connection.
-----Original Message-----
From: Eion McIntosh (CHCH) [mailto:[EMAIL PROTECTED]]
Sent: 27 March 2001 13:59
To: Multiple recipients of list delphi
Subject: [DUG]: ODBC/SQL Server
Hello
I wonder if somebody can help but I am running a Delphi 4 application using
data from an SQL database.
It nearly all works fine. I have set up the ODBC connection using Windows NT
authentication option and the BDE connection. I have the user setup under
the SQL users and have managed to get it to use this as the login name but
everytime the application starts and makes the connection it asks for a
password.
I am initiating the application from a Windows NT workstation but it is
running on the server. The app starts, runs a task and then closes. When it
starts it asks for the user ids password which is also the user that is
logged onto the server.
I have tried having the BDE configuration with the user id setup under the
parameters and tried it with no default id.
How can I stop this app asking for this password or can I somehow get it to
automatically pass the password for it to recognize.
Regards
Eion McIntosh
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
