Ask a Question related to ASP Database, Design and Development.
-
K. Lobe #1
Persisted XML Recordsets - Disconnected Recordsets - problems
I have a recordset, client side .ASP that I save as a DOM. I pass to a
server side .ASP to reconnect the recordset and update. I keep getting an
error and can't figure it out. Hopefully someone here knows what is going
on. Thanks
'Client' .asp
Set REQ=GetObject("","MSXML2.XMLHTTP")
Set DOM = GetObject("","MSXML2.DOMDocument")
If rsBPO.EditMode<>0 Then
rsBPO.Save DOM,1
REQ.Open "POST","http://" + window.location.host +
"/PreBoarding/_Testing/UpdateData.asp",false REQ.Send DOM
str=CStr(REQ.responseText)
End If
Set REQ=Nothing
Set DOM=nothing
'Server' side .ASP UpdateData.asp (should work for any recordset sent as
DOM)
dim objDOM, objConn, objRst
set objDOM = Server.CreateObject("Msxml2.DOMDocument")
objDOM.load(Request)
set objRst = Server.CreateObject("ADODB.Recordset")
objRst.Open objDOM
set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open strCN
objConn.BeginTrans
objRst.ActiveConnection = objConn
objRst.UpdateBatch
objConn.CommitTrans
Response.Expires = 0
Response.Buffer = False
Response.Write "Finished"
objRst.Close
Set objRST=nothing
set objDOM=nothing
objConn.Close
Set objConn=nothing
---------------------
It errors out on the Recordset trying to open the objDOM. I get this...
Error Type:
Microsoft OLEDB Persistence Provider (0x80040154)
Persisted XML files cannot be opened with the version of the Microsoft XML
Parser currently installed on this computer. Upgrade your system through a
Windows 95/98 Service Release or Internet Explorer 5.0 or later.
/PreBoarding/_Testing/UpdateData.asp, line 11
I think I'm using backward compatibale XML drivers. I don't have a problem
getting the data in a stream back to client page and turning them into a
recordset, so not sure why I'm having a problem going to other what. Hope
someone has done this successfully.
Thanks,
Kevin
K. Lobe Guest
-
ASP Recordsets
Hi there, i'm developing an ASP SQL application, and was just wondering whether for some reason this limited me to one recordset per page. the... -
disconnected recordsets and eof
I know this may sound stupid, but when you use a disconnected recordset can you check for eof or bof, i assume you can just i get an error even when... -
when to use connection method over disconnected recordsets
When if ever should you use a connected recordset. I am using disconnected recordsets throughout my site as they are quicker, and after learning... -
Do I have the right idea about using recordsets?
Hi, I'd like to set the caption for a group of labels on an unbound form depending on the presence of a record in a table. That is, if a record... -
generating recordsets
50k records should load almost instantaneously if the form is based on a single table, and there are indexes on the appropriate fields for selecting...



Reply With Quote

