Users have copied and pasted from an app into a textbox on a website, then saved the record. However when it came to viewing the record again the page threw an error.
It had some special characters, UTF-8 encoded.
I have added the following to the pages:
<% Response.CodePage = 65001 %>
<% Response.Charset="UTF-8" %>
<meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
When loading the page it retrieves the recordset fine but fails to load the recordset into a DOM object.
Set adoCn = Server.CreateObject("ADODB.Connection")
adoCn.Open Application("conn_string")
Set objCommand = Server.CreateObject("ADODB.Command")
Set objDOM = Server.CreateObject("Msxml2.DOMDocument.3.0")
objCommand.ActiveConnection = Application("conn_string")
spQry = "SP_QUERY"
objCommand.CommandText = spQry
objCommand.CommandType = adCmdStoredProc
Set objRs = objCommand.Execute
objRS.save objDOM, adPersistXML //Crashes here
Set objCommand = Nothing
objRS.Close
adoCn.Close
Set objRS = Nothing
This is the error Microsoft OLEDB Persistence Provider error 'c00ce508' Unknown error.
What else can I do to fix this?
Tiada ulasan:
Catat Ulasan