[AccessD] Using MSXML2 on old machines - No dice

[Darryl Collins]

Yes... This was my thoughts too.  Can you mod the default security zone settings in IE itself.

Oddly you need to this for other permissions as well I have noted in the past.

Hopefully MS Edge avoids this kind of SNAFUs....



-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: Thursday, 23 July 2015 8:01 PM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Using MSXML2 on old machines - No dice

From:  https://msdn.microsoft.com/en-us/library/ms537505%28v=vs.85%29.aspx

Note   In Internet Explorer 7, the default settings for cross-domain data access are set to 
"deny" for all security zones.

Can you get the server admins to modify IE's Security Manager to allow access to the site in question (or can you do that yourself?)



On 23 Jul 2015 at 16:52, Darren- Active Billing wrote:

> Hi Team,
> With the help of the very clever Mr. McLachlan, I have been able to
> build a nice tool that performs an API request and returns the
> relevant data I need. All done using CreateObject("Msxml2.XMLHTTP") -
> All very cool - Works a treat - On my local Windows 8 machine. 
> 
> When I tried to run this Access dB on our old Win 2003 Servers (there
> are 2 - both are actually VMs) running IE7 and IE8 - It fails. (I have
> no control over these servers BTW - not mine to manage and the last
> time I rebooted one it did not come "back up" and caused chaos)
> 
> Anyway - after a week of googling and various attempts at resolution I
> have discovered the issue is because I am running my API request
> against is an HTTPS site and not an HTTP site.Turns out Older versions
> of IE are either incapable of accessing HTTPS sites or requests to
> them are not being processed. This really is an area I have absolutely
> no clue about.
> 
> On each of our Win2003 Servers if I paste the API request URL into the
> Address field of Firefox or Chrome- I get results. Cool. It's just IE
> is the issue. IE won't load an HTTPS sites outside our domain (i.e.
> from the real world) IE will load our own internal HTTPS Sites hosted
> on our same server and domain. But nothing from the outside world. 
> 
> And yes, I have wasted hours and hours over this trying every
> conceivable suggestion by the Google world. But obviously not the one
> I need :-) Googling phrases and words such as "HTTPS not accessible
> IE7" or IE8 can't access https site" yields a whole world of pain for
> a great many folk. And the majority of suggestions I truly have tried
> - Maybe there is one more I haven't that will be the solution. Happy
> to try whatever you suggest.
> 
> So...my question is - Anyone know of an alternative to
> CreateObject("Msxml2.XMLHTTP") or a way to get IE7 or 8 to access
> HTTPS sites in the outside world.
> 
> Sorry for the long post - Many thanks in anticipation
> 
> D
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com