Board index » delphi » Passing Username and Password on connection to MSSQL...

Passing Username and Password on connection to MSSQL...

how do i provide the required username and password to the MSSQL
server so the log-in dialog does not pop up ?

TIA

c ya
__
\__HRIS

 

Re:Passing Username and Password on connection to MSSQL...


Quote
"Christoph Klaja" <chriss...@binary-dreams.de> wrote in message

news:39fe9606.8804109@News.CIS.DFN.DE...

Quote
> how do i provide the required username and password to the MSSQL
> server so the log-in dialog does not pop up ?

Set "LoginPrompt" to false on whatever type of connection you're using, i.e.
TDatabase or TADOConnection.

Pass the User Name and Password to the server via the Parameters or
Connection String (depending on which type of conn you're using).

Re:Passing Username and Password on connection to MSSQL...


Set up a "database" component to go along with your table and datasource.
Hook the database to an alias, and then give the database a name, e.g., DB1.
Then hook the table up to "alias" DB1.  Hook up the datasource as usual.

Now, double click the database, and you'll get a "properties" type dialog.
Just put in the username and password.  Simple.

Hope this helps.

Ken

Quote
"Christoph Klaja" <chriss...@binary-dreams.de> wrote in message

news:39fe9606.8804109@News.CIS.DFN.DE...
Quote
> how do i provide the required username and password to the MSSQL
> server so the log-in dialog does not pop up ?

> TIA

> c ya
> __
> \__HRIS

Other Threads