[AccessD] Using MSXML2 on old machines - No dice

[Martin Reid]

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