[AccessD] Using MSXML2 on old machines - No dice

[Jim Lawrence]

Hi Darren:

Yes, both these programs are "too old"...but just like XP (...and are full of zero-day bugs), getting clients, to anti-up, to a potentially massive bill, for products, with qualities, that they have serious suspicions about, is going to be a very ssssslllloooowwwwwwww process.

Jim 

----- Original Message -----
From: "Darren - Active Billing" <darren at activebilling.com.au>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Wednesday, July 29, 2015 11:11:54 PM
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