Application Role - Slow Response
From: Daniela Guerra (danielamguerra@hotmail.com)
Date: 06/24/02
- Next message: Schnyder Daniel: "Change username of "SA""
- Previous message: Daniela Guerra: "Application Role - Slow Response"
- In reply to: 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 08:21:35 -0700
Sorry,
I did a mistake.
The connection is always quickly.
It's not the connection but the execution of a statement
SQL that is very slow.
Ex after the connection :
sql = "SELECT * FROM table"
set recServeur=conn.execute (sql)
>-----Original Message-----
>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: Schnyder Daniel: "Change username of "SA""
- Previous message: Daniela Guerra: "Application Role - Slow Response"
- In reply to: Daniela Guerra: "Application Role - Slow Response"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
