Office 2016 Access VBA sending XML (1 Viewer)

jessss

Registered User.
Local time
Today, 12:16
Joined
Jan 17, 2010
Messages
29
[Solved] Office 2016 Access VBA sending XML

Hi,


I am upgarding to Microsoft Office and a piece of VBA which sends XML to a web address has stopped working. It uses Microsoft Soap Type Library v3.0 and produces an error saying "Active X component can't create object" when it tries to set a variable as a new SoapClient 3.0



Does anyone know why it would produce this error in Office 2016 but not Office 2013?


Thanks for any help anyone could give me in advance
 
Last edited:

June7

AWF VIP
Local time
Today, 03:16
Joined
Mar 9, 2014
Messages
5,468
Not finding much info about this Library and what I did see is old. But maybe a clue in https://support.microsoft.com/en-gb...esolve-reference-issues-in-an-access-database

ActiveX component can't create object"

This error message does not necessarily mean that an ActiveX control is involved. For example, one possible cause is that DAO, which is an ActiveX component, cannot create an object because the DAO Automation Server cannot start. Frequently, the cause is that DLLs that provide referenced functionality for the program are not registered or are incorrectly registered.

And https://social.msdn.microsoft.com/F...erence-microsoft-office-soap-type-library-v30
 

jessss

Registered User.
Local time
Today, 12:16
Joined
Jan 17, 2010
Messages
29
Found reason why its stopped working, it was because I was using 64 bit office 2016 instead of 32 bit. Problem is now solved. But thanks for replying
 

isladogs

MVP / VIP
Local time
Today, 12:16
Joined
Jan 14, 2017
Messages
18,211
Found reason why its stopped working, it was because I was using 64 bit office 2016 instead of 32 bit. Problem is now solved. But thanks for replying

So did you solve it by updating your API declarations for 64-bit, swopping to 32-bit Office 2016 or by removing the reference?

For the benefit of others who may read this in the future, can you please explain:
a) How you resolved the issue?
b) What the Microsoft Soap Type Library v3.0 actually does?
 

Insane_ai

Not Really an A.I.
Local time
Today, 07:16
Joined
Mar 20, 2009
Messages
264
Microsoft Soap Type Library v3.0




Since these articles seem to be disappearing I'll include the primary content form the page:
https://support.microsoft.com/en-us...t-versions-2-0-and-3-0-on-windows-server-2003
Microsoft SOAP Toolkit provides limited support for applications that must run on the Microsoft Windows Server 2003 operating system. Please note that all SOAP Toolkits have been replaced by the Microsoft .NET Framework. SOAP Toolkit versions earlier than version 3.0 are no longer supported. Standard support for SOAP Toolkit 3.0 expired March 31, 2005, and extended support will expire March 31, 2008.

SOAP Toolkit Version 2.0
SOAP Toolkit version 2.0, including Service Pack 1 (SP1) and Service Pack 2 (SP2), is no longer supported.

If your application uses SOAP Toolkit version 2.0 to develop XML Web services and you plan to host these services on the Windows Server 2003 operating system, Microsoft recommends that you do one of the following:
Use the Microsoft .NET Framework (that is, implement .NET XML Web services or use .NET Remoting).
Use COM+ SOAP feature on Windows Server 2003.
If your application uses SOAP Toolkit version 2.0 to consume XML Web services and must run on the Windows Server 2003 operating system, Microsoft recommends that you use Microsoft .NET Framework to consume the XML Web Service.
SOAP Toolkit Version 3.0
Microsoft does not recommend that you use SOAP Toolkit 3.0 on computers that are running Windows Server 2003. There is limited support for Soap Toolkit 3.0 when you upgrade existing applications from earlier versions of Windows to Windows Server 2003. No new development should be performed with SOAP Toolkit 3.0. Existing applications that are built on SOAP Toolkit should be upgraded to a .NET-based solution as soon as possible.

SOAP Toolkit version 3.0 client components and corresponding low-level client-side APIs are supported on the Windows Server 2003 operating system in limited scenarios. The client components and low-level client-side APIs are supported in desktop client application scenarios. They are not supported in server-side (middle-tier) application scenarios.

SOAP Toolkit 3.0 server components and SOAP Toolkit ISAPI Listener are not supported on the Windows Server 2003 operating system.

If your application uses SOAP Toolkit version 3.0 to develop XML Web services, Microsoft recommends that you do one of the following:
Use the Microsoft .NET Framework (that is, implement .NET XML Web Services or use .NET Remoting).
Use COM+ SOAP feature on Windows Server 2003.
References

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:
Creating XML Web Services in Managed Code
http://msdn2.microsoft.com/en-us/library/3x5e7527(vs.71).aspx

An Introduction to Microsoft .NET Remoting Framework
http://msdn2.microsoft.com/en-us/library/ms973864.aspx

COM+ Web Services: The Check-Box Route to XML Web Services
http://msdn2.microsoft.com/en-us/library/ms973810.aspx
 

jessss

Registered User.
Local time
Today, 12:16
Joined
Jan 17, 2010
Messages
29
I managed to solve my issue by switching to Office 2013 32bit, sorry if i forgot to mention this orginally
 

jleach

Registered User.
Local time
Today, 07:16
Joined
Jan 4, 2012
Messages
308
>> 32bit <<

That was going to be my guess. Usually a broken Active X would mean that either a) the library was removed from the system (not likely in the case of the MSXML parser), or when you migrated you went to 64bit, which needs different libraries.
 

Users who are viewing this thread

Top Bottom