[AccessD] Using MSXML2 on old machines - No dice

Darren- Active Billing darren at activebilling.com.au
Fri Jul 24 11:39:31 CDT 2015


Stuart & Darryl,
Thanks for the replies/comments.
Stuart - I have in various edits across the weeks played with the 'cross
domain access'.
Tools | Internet Options | Security Tab | (Zones) Internet (and the others)
| Custom Level and scroll (5xPage Downs) to the "Access data Sources Across
Domains". 
Is that where you meant?
Anyway - After reading your post I went back in and edited all the zones
(Internet, Intranet, Trusted Sites and restricted) - to all 'enable' Cross
domain Access.
No joy, sadly
Many thanks in advance
D
 
 

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

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

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



More information about the AccessD mailing list