Application Role - Slow Response

From: Daniela Guerra (
Date: 06/24/02

From: "Daniela Guerra" <>
Date: Mon, 24 Jun 2002 07:55:49 -0700

I did a web application (asp).
I can open the connection with or without use a
application role but when I use the application role, the
connection is very slow and sometimes I have a timeout,
sometimes it's works. When I don't use the application
role it's works quickly. Why?
Thanks in advance,


Const ChaineConnexion = "Provider=SQLOLEDB.1;OLE DB
Services = -2;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=DataBaseName;Data

Set conn = Server.CreateObject("ADODB.Connection")
conn.Open ChaineConnexion
'conn.Execute("EXEC sp_setapprole 'RoleName', {ENCRYPT
N 'password'}, 'ODBC'")