IjumpOverU
Technical User
In one of my programs we query a database through COM+ and return a recordset in xml format. The problem also only occurs when more than approximatly 10,000 records are returned. When it runs on a 2003 server the following code generates an error:
try {
http = new ActiveXObject("Microsoft.XMLHTTP")
try {
http.open("POST", urlHTTP, false)
http.send(sXML)
if (http.status == 200) {
if (flagRS) {
rs.Open(http.responseXML)
}
else {
rXML = http.responseText
res = new String(rXML)
if (res.indexOf("<result>0<", 0) <= 0) {
LastErrDesc = GetErrDesc(rXML)
return -1
}
}
return 0
}
else {
LastErrDesc = "HTTP Error : " + http.status + ", Description : " + http.statusText
alert(LastErrDesc)
}
}
The error occurs on the statement: rs.Open(http.responseXML)
The error reads: XML error top level element not defined.
It appears that the xml or the creation of the recordset is limited to a certain number of characters. Because jusding from the error messgaes the end of the xml is cut off (so the xml structre is invalid).
The odd thing is when this runs on a XP Pro box it works fine regaurdless of how many records are returned.
Does anyone know of a length restriction or record count issue in 2003? Or any other ideas are greatly appreciated.
try {
http = new ActiveXObject("Microsoft.XMLHTTP")
try {
http.open("POST", urlHTTP, false)
http.send(sXML)
if (http.status == 200) {
if (flagRS) {
rs.Open(http.responseXML)
}
else {
rXML = http.responseText
res = new String(rXML)
if (res.indexOf("<result>0<", 0) <= 0) {
LastErrDesc = GetErrDesc(rXML)
return -1
}
}
return 0
}
else {
LastErrDesc = "HTTP Error : " + http.status + ", Description : " + http.statusText
alert(LastErrDesc)
}
}
The error occurs on the statement: rs.Open(http.responseXML)
The error reads: XML error top level element not defined.
It appears that the xml or the creation of the recordset is limited to a certain number of characters. Because jusding from the error messgaes the end of the xml is cut off (so the xml structre is invalid).
The odd thing is when this runs on a XP Pro box it works fine regaurdless of how many records are returned.
Does anyone know of a length restriction or record count issue in 2003? Or any other ideas are greatly appreciated.