Loading XML into OWCPivot via ADODB

J

Josiah Fizer

Not sure this is the right forum for this question, but I'm stumped
and it never hurts to ask.

Due to security fixes from Microsoft we can no longer load XML data
into the OWC Pivot Tables using an ADODB.Stream.

However the following code will load the remote XML file directly into
the ADODB.Recordset over HTTP.

For some reason however it breaks when used over SSL (HTTPS).

Any thoughts?

<script language=javascript>
function LoadData()
{
var objRecordset = new ActiveXObject('ADODB.Recordset');
var strConnectionString = 'Provider=MSPERSIST';
var strQuery = jsvProtocolServer; // URL to the XML file.
try {
objRecordset.Open(strQuery, strConnectionString);
if (!objRecordset.EOF)
{
document.pt.DataSource = objRecordset;
//Automatically displays all columns on the pivottable
document.pt.ActiveView.AutoLayout();
}
}
catch(e) {alert('No Data Returned');}
}
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top