[AccessD] Using MSXML2 on old machines - No dice

[Jim Lawrence]

An excellent link Jim. :-)

Jim

----- Original Message -----
From: "Jim Dettman" <jimdettman at verizon.net>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Thursday, July 30, 2015 12:01:17 PM
Subject: Re: [AccessD] Using MSXML2 on old machines - No dice


 I would seriously doubt that unless I saw it first hand.   SSL over HTTP
has been around forever.

 While I don't have an exact answer for you, my suggestion would be to turn
on logging for IE, then check the Windows Event Viewer for any errors or
warnings.  Might give you a clue as to what's going on.

 Better yet, download fiddler:

http://www.telerik.com/fiddler

 But be ready to dive in deep end.

Jim. 

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Darren - Active Billing
Sent: Thursday, July 30, 2015 02:12 AM
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