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