Re: username

From: David (dgallaher_at_quantum.ca)
Date: 11/24/04 

Date: Wed, 24 Nov 2004 00:14:48 -0500

Try double clicking on the TADOConnection, this will open a dialog box,
Click on build and there you can enter user name, password, database an so
on.
"Brian Bushay TeamB" <BBushay@Nmpls.com> wrote in message
news:sna5q0dhjtj3m3inv44i2i5470itqfdfk9@4ax.com...
>
>>How do i obtain the username in my delphi application used to logon to
>>SQL-server tru an ADO-connection.
>>The ADOConnection component seems to have no way to determine the
>>username.
>>I guess i could write a sproc to return it but i do not what to get down
>>to
>>the dbms itself.
>
> You can check the AdoConnection.Properties
> ADOConnection.Properties['User ID'].Value
> --
> Brian Bushay (TeamB)
> Bbushay@NMPLS.com

Relevant Pages

  • Re: Create Database in MS Access. & set properties of fields.
    ... Brian Bushay TeamB wrote: ... Access is the only database I know that supports the Allow Zero length property. ... Catalog1. ...
    (borland.public.delphi.database.ado)
  • Re: Batchmove & ADO
    ... Brian Bushay TeamB wrote: ... I have a TService which currently uses a datamodule plus several TBatchmove components to move data from a SQL Server Database -> Oracle database. ...
    (borland.public.delphi.database.ado)
  • Re: strategy for record locking in multiuser environment
    ... I am using an Access 2000 database ... "Brian Bushay TeamB" wrote in message ... >>overwrite another users entries and so each user can see the changes or ...
    (borland.public.delphi.database.ado)
  • Re: TADOConnection opens in design time
    ... function GetConnectionString(ConnectionString: string): string; ... ADOConnect: TADOConnection; ... "Brian Bushay TeamB" wrote in message ...
    (borland.public.delphi.database.ado)
  • RE: dbgrid refreshing problems...
    ... Brian Bushay TeamB escribió en el mensaje de noticias ... > reload records from the database. ...
    (borland.public.delphi.database.ado)