[AccessD] Using MSXML2 on old machines - No dice

Darren - Active Billing darren at activebilling.com.au
Thu Jul 30 20:03:33 CDT 2015


Hi Guys

Many thanks to all the suggestions.

Jim D - Not my server to play with, really.(sadly)
Martin - Yes, have tried it and tried it again to no avail.
Jim L - thanks - but it seems you may well be right - “too old”

Many thanks

Darren - Active Billing

0424 696 433

> On 31 Jul 2015, at 5:28 am, Martin Reid <mwp.reid at qub.ac.uk> wrote:
> 
> Likely done but what about enhanced browser security as your on a server?
> 
> Martin
> ________________________________
> From: Jim Dettman<mailto:jimdettman at verizon.net>
> Sent: ‎30/‎07/‎2015 20:02
> To: 'Access Developers discussion and problem solving'<mailto:accessd at databaseadvisors.com>
> 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
> -- 
> 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