application rolls and ADO.Net

Hi.
Is it possible to get the benefit of application rolls with
the new ADO.Net drivers?
Do i have to call "sp_setapprole" for every connection?
best regards,
JanThe answer to both questions is yes.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Application roles have the same limitations in ADO.NET that they did
in ADO classic. See:
PRB: SQL Application Role Errors with OLE DB Resource Pooling
(Q229564)
http://support.microsoft.com/defaul...B;EN-US;Q229564
--Mary
On Mon, 14 Jun 2004 10:05:40 +0200, Jan Weingrtner <jweingart@.gmx.de>
wrote:

>Hi.
>Is it possible to get the benefit of application rolls with
>the new ADO.Net drivers?
>Do i have to call "sp_setapprole" for every connection?
>best regards,
>Jan|||Hi.
Thanks, for the infos.
I have a further question in relation to application rolls.
Does ADO.Net support the encryption of the password for the
application roll?
best regards,
Jan|||Take a look at using DPAPI for that:
d12.asp" target="_blank">http://msdn.microsoft.com/library/d...
d12.asp
- Stephen
"Jan Weing?rtner" wrote:

> Hi.
> Thanks, for the infos.
> I have a further question in relation to application rolls.
> Does ADO.Net support the encryption of the password for the
> application roll?
> best regards,
> Jan
>