Application Role - Slow Response
From: Daniela Guerra (danielamguerra@hotmail.com)
Date: 06/24/02
- Next message: Daniela Guerra: "Application Role - Slow Response"
- Previous message: BP Margolin: "Re: SQL Permissions"
- Next in thread: Daniela Guerra: "Application Role - Slow Response"
- Reply: Daniela Guerra: "Application Role - Slow Response"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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'")
- Next message: Daniela Guerra: "Application Role - Slow Response"
- Previous message: BP Margolin: "Re: SQL Permissions"
- Next in thread: Daniela Guerra: "Application Role - Slow Response"
- Reply: Daniela Guerra: "Application Role - Slow Response"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
