Error de ADO en linea
Publicado por Owen Bonilla (2 intervenciones) el 08/06/2001 20:49:58
Soy principiante, estoy aprendiendo apenas este lenguaje (ASP). En mi programa para registro de usuarios tengo este error:
--------------------------------------------------------------------------------------------------
ADODB.Recordset error '800a0e7d'
The application requested an operation on an object with a reference to a closed or invalid Connection object.
/asp/form.asp, line 360
---------------------------------------------------------------------------------------------------
Este es parte del codigo:
---------------------------------------------------------------------------------------------------
Set oConn = Server.CreateObject("ADODB.Connection")
Set rs= Server.CreateObject("ADODB.RecordSet")
rs.open "registro", oConn, 3, 3, adCmTable
rs.Open SQL, oConn
rs.AddNew
rs("Nombre")=Trim(Request.Form("sNombre"))
rs("Apellido")=Trim(Request.Form("sApellidos"))
rs("NombreUsuario")=Trim(Request.Form("sLogin"))
rs("password")=Trim(Request.Form("spass"))
rs("Correo")=Trim(Request.Form("sEmail"))
---------------------------------------------------------------------------------------------------
la linea 360 es: rs.Open "registro", oConn, 3, 3, adCmTable
En donde estoy equivoado :(
--------------------------------------------------------------------------------------------------
ADODB.Recordset error '800a0e7d'
The application requested an operation on an object with a reference to a closed or invalid Connection object.
/asp/form.asp, line 360
---------------------------------------------------------------------------------------------------
Este es parte del codigo:
---------------------------------------------------------------------------------------------------
Set oConn = Server.CreateObject("ADODB.Connection")
Set rs= Server.CreateObject("ADODB.RecordSet")
rs.open "registro", oConn, 3, 3, adCmTable
rs.Open SQL, oConn
rs.AddNew
rs("Nombre")=Trim(Request.Form("sNombre"))
rs("Apellido")=Trim(Request.Form("sApellidos"))
rs("NombreUsuario")=Trim(Request.Form("sLogin"))
rs("password")=Trim(Request.Form("spass"))
rs("Correo")=Trim(Request.Form("sEmail"))
---------------------------------------------------------------------------------------------------
la linea 360 es: rs.Open "registro", oConn, 3, 3, adCmTable
En donde estoy equivoado :(
Valora esta pregunta


0