What does this mean and how can I resolve this?

Results 1 to 2 of 2

Thread: What does this mean and how can I resolve this?

  1. #1
    Join Date
    Dec 1969

    Default What does this mean and how can I resolve this?

    When I run this ASP code:<BR><BR>&#060;%<BR>Response.AddHeader "Pragma", "No-cache"<BR>&#039; Response.AddHeader "Expires", Now<BR>Response.cachecontrol="private"<BR>Response .ExpiresAbsolute = Now() - 1<BR>Server.ScriptTimeout = 999999999<BR><BR>XNroPerfil = Request.Form("NroPerfil")<BR>XNrosEmpleadores = Request.Form("NrosEmpleadores")<BR>XIDCandidato = Request.Form("IDCandidato")<BR>XPWCandidato = Request.Form("PWCandidato")<BR><BR>if Session("USBActiva") = "" then<BR> Response.Redirect "expotalento.asp"<BR>end if<BR><BR>if XNroPerfil &#060;&#062; "" then<BR> Set Conexion = Server.CreateObject("ADODB.Connection")<BR> Conexion.Open "DBPerfilNet1", "jportillo", "jportillo00"<BR> Set Conjunto1 = Server.CreateObject("ADODB.RecordSet")<BR><BR> if XNrosEmpleadores &#060;&#062; "" then<BR> XAEmpleadores = Split(XNrosEmpleadores,",")<BR> &#039;Response.Write XNrosEmpleadores<BR><BR> for i = 0 to UBound(XAEmpleadores)<BR> <BR> SentenciaSQL = "SELECT * FROM EmpleadoresCandidatos " &_<BR> "WHERE NroEmpleador = " & XAEmpleadores(i) &_<BR> "AND NroPerfil = " & XNroPerfil<BR> Conjunto1.Open SentenciaSQL, Conexion<BR> XSiSePuede = false<BR> if Conjunto1.EOF then<BR> XSiSePuede = true<BR> end if<BR> Conjunto1.Close<BR><BR> if XSiSePuede then<BR> SentenciaSQL = "INSERT INTO EmpleadoresCandidatos " &_<BR> "(NroEmpleador, NroPerfil, FAplicacion) " &_<BR> "VALUES " &_<BR> "(" & XAEmpleadores(i) & ", " & XNroPerfil & ", GETDATE())"<BR> Conjunto1.Open SentenciaSQL, Conexion &#039; &#060;&#060; Line 44<BR> end if<BR> next<BR> end if<BR>end if<BR><BR>SentenciaSQL = "SELECT IDCandidato, PWCandidato " &_<BR> "FROM CandidatosBase " &_<BR> "WHERE NroPerfil = " & XNroPerfil<BR><BR>Conjunto1.Open SentenciaSQL, Conexion<BR><BR>if not Conjunto1.EOF then<BR> XIDCandidato = Conjunto1("IDCandidato")<BR> XPWCandidato = Conjunto1("PWCandidato")<BR>end if<BR><BR>Conjunto1.Close<BR><BR><BR>&#039; Env*o de un mail de bienvenida para el nuevo candidato - JGC<BR>&#039; Creación del objeto mail.<BR>Set Mensajero = Server.CreateObject("Persits.MailSender")<BR><BR>S entenciaSQL = "SELECT EmailPersonal " &_<BR> "FROM CandidatosBase " &_<BR> "WHERE NroPerfil = " & XNroPerfil<BR>Conjunto1.Open SentenciaSQL, Conexion<BR>XEmailPersonal = Conjunto1(0)<BR>Conjunto1.Close <BR><BR>&#039; Asignación de las propiedades principales<BR>Mensajero.Host = "mail.perfilnet.com"<BR>Mensajero.From = "info@perfilnet.com"<BR>Mensajero.FromName = "Perfilnet.com"<BR>Mensajero.AddAddress XEMailPersonal<BR>Mensajero.ContentTransferEncodin g = "quoted-printable" <BR><BR>&#039;set FSO = Server.CreateObject("scripting.FileSystemObject")< BR>&#039;set f = fso.GetFile("C: est1.txt")<BR><BR>&#039; Obtención del cuerpo del mensaje<BR><BR>SentenciaSQL1 = "SELECT * FROM MensajesCorreo WHERE NombreMensaje = &#039;expotalento&#039;"<BR>Conjunto1.Open SentenciaSQL1, Conexion<BR>XCuerpoMensaje = Conjunto1("CuerpoMensaje")<BR>Mensajero.Subject = Conjunto1("TituloMensaje")<BR>Conjunto1.Close<BR>C onexion.Close<BR>Mensajero.Body = XCuerpoMensaje<BR>Mensajero.Body = replace(Mensajero.Body, "&#060;IDCandidato&#062;", XIDCandidato)<BR>Mensajero.Body = replace(Mensajero.Body, "&#060;PWCandidato&#062;", XPWCandidato)<BR><BR>&#039; Env*o del mensaje<BR>On Error Resume Next <BR>Mensajero.SendToQueue <BR><BR><BR>Session("YError_Back") = "Se registraron correctamente los empleadores seleccionados para el candidato en cuestión."<BR>Response.Redirect "expotalento_02.asp"<BR>%&#062;<BR><BR>...I get this error message:<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039;80040e14&#039; <BR><BR>[Microsoft][ODBC SQL Server Driver][SQL Server]Could not allocate space for object &#039;EmpleadoresCandidatos&#039; in database &#039;Perfilnet1&#039; because the &#039;PRIMARY&#039; filegroup is full. <BR><BR>/expotalento_04.asp, line 44 <BR><BR>What could be happening? How could I resolve this?<BR><BR>Thanks for your responses.<BR><BR><BR>Julio<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: What does this mean and how can I resolve this

    My guess is that you&#039;ve run out of space on your SQL Server drive. Make sure you&#039;re using varchars instead of chars, that already can help. Chars are of set lengths, for example, if you set a char(5), it takes up 5 bytes of space, even if you have &#039;abc&#039; in that record. Instead with varchar, you would only take up 3. So, possibly, if you haven&#039;t been too too careful with your memory allocations, space could have run out.<BR><BR>This is my guess.<BR><BR>-Vadim C.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts