[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 390
  • Last Modified:

Error when Accessing a COM+ WCF Addin consuming a Webservice from MS Access 2007

Hi!
I am trying to access a Com+ Add-IN within MS Access 2007. In the Com+ Addin a external Webservice is referenced.

I can see all the published objects and methods from VBA - but when I trigger the Method which accesses the external Web Service I am receiving the error message:

"Could not find default endpoint element that references contract ‘stripped out’
in the ServiceModel
client configuration section.  
This might be because no configuration file was found for your application
or because no endpoint element matching this contract could be found in the
client element."

I have investigated a lot of time in this problem - what I have found out is that I have to
modify the applications app.config file and that I have to include the service endpoint references there...
It´s clear to me for a visual studio applicaton - but I have no glue how to handle this issue within MSAccess...

I have also tried to compile the app.config file directly into the DLL - but the result is the same

Please Help!!!!!!
0
Martins_Vienna
Asked:
Martins_Vienna
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Access can't really consume web services, unless you can do so through SOAP, and even then it's a hair-pulling exercise. You're better off writing a small applet in .NET that can use that web service, then providing the output to Access through some other methods (text files, writing to the database, etc etc).

0
 
Martins_ViennaAuthor Commented:
Thannk you! That input helped a lot!
0
 
Martins_ViennaAuthor Commented:
Great input - thank you!
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now