[AccessD] Using MSXML2 on old machines - No dice

[Darren - Active Billing]

Hi Martin
Thanks for the reply. Yes, I have tried it (In the IE8Version) but no joy
Even selected to show all site in compatibility mode as well as the desired https site.
Many thanks
Darren

> On 30 Jul 2015, at 4:35 pm, Martin Reid <mwp.reid at qub.ac.uk> wrote:
> 
> Darren
> 
> You likely have tried this in your google searching but it solved a number of issues for us. Try using compatibility view in the browser?
> 
> Martin
> 
> 
> 
> 
> -----Original Message-----
> From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren - Active Billing
> Sent: 30 July 2015 07:12
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Using MSXML2 on old machines - No dice
> 
> Hi All,
> Anyone have any thoughts on this? 
> It can’t be that WinServer2003 and IE8 is just “too old” for HTTPS…can it?
> Many thanks
> Darren
> 
>> On 25 Jul 2015, at 2:39 am, Darren- Active Billing <darren at activebilling.com.au> wrote:
>> 
>> 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
>> 
>> --
>> 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