ASP Time out en un conn.execute de un stored procedure

02/02/2004 - 20:55 por Luis Esteban Valencia | Informe spam
My page is having this error

update mesciclo set mes = 01, ano 04 where id=1
Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/logistica/reciclopedido2.asp, line 134


The code of the page is this.

See the line 2. It seems it doesnt work.s

<%
Set Conn = Server.CreateObject("ADODB.Connection")
conn.connectiontimeout = 0
Conn.open = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=True;" & _
"User ID=sa;" & _
"Initial Catalog=asw;" & _
"Data Source=MED13NT"

sql ="update mesciclo set mes = "&request.form("mes")&",
ano="&request.Form("ano")&" where id=1"
response.write sql
conn.execute(sql)

conn.execute("exec ciclo_pmes")
THE ERROR IS IN THIS LINE.
 

Leer las respuestas

#1 Adrian D. Garcia
03/02/2004 - 07:45 | Informe spam
Intenta:

Conn.CommandTimeout = 120 'expresado en segundos

Antes de ejecutar el comando.

Saludos
Adrian D. Garcia
MCSD
NDSoft Consultoria y Desarrollo


"Luis Esteban Valencia" wrote in message
news:
My page is having this error

update mesciclo set mes = 01, ano 04 where id=1
Microsoft OLE DB Provider for SQL Server error '80040e31'

Timeout expired

/logistica/reciclopedido2.asp, line 134


The code of the page is this.

See the line 2. It seems it doesnt work.s

<%
Set Conn = Server.CreateObject("ADODB.Connection")
conn.connectiontimeout = 0
Conn.open = "Provider=SQLOLEDB.1;" & _
"Persist Security Info=True;" & _
"User ID=sa;" & _
"Initial Catalog=asw;" & _
"Data Source=MED13NT"

sql ="update mesciclo set mes = "&request.form("mes")&",
ano="&request.Form("ano")&" where id=1"
response.write sql
conn.execute(sql)

conn.execute("exec ciclo_pmes")
THE ERROR IS IN THIS LINE.



Preguntas similares