Application Role - Slow Response

From: Daniela Guerra (danielamguerra@hotmail.com)
Date: 06/24/02


From: "Daniela Guerra" <danielamguerra@hotmail.com>
Date: Mon, 24 Jun 2002 07:55:49 -0700


Hello,
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,
Daniela

Code:

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

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