Re: Newbie question - how to use Web Service function in Access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I guess it would be much easier if the webservice in question supports HTTP
POST requests rather than using SOAP. I've not looked into it, but i'm sure
VBA must have some functions to help with HTTP requests and responses.

Andrew

"Scott M." <s-mar@xxxxxxxxxxxxx> wrote in message
news:OfW2MNsoHHA.716@xxxxxxxxxxxxxxxxxxxxxxx
Your going to have a harder time accessing the service from within access.
You'll have to make the SOAP Requests and process the SOAP Responses
manually. Access is not a .NET application, so none of the .NET Framework
stuff will help you.


"Dave" <dgmoore@xxxxxxxxx> wrote in message
news:1180525745.624040.73240@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On May 30, 3:57 am, "Andrew Brook" <yko...@xxxxxxxxxxx> wrote:
Hi Dave,

Have the developers given you a WSDL file? This file would contain all
the
information you would need to access the webservice. As well as this, do
you
intend to use VBA to transfer the data?

I'd just write a VB.NET application to open your access database, and
call
the webservice. If you have the location of the WSDL file then you can
simply 'add a web reference' from inside VS and point it at the file. A
class will then be generated for you that will hide some of the
complexity.

hope this helps,
Andrew

"Dave" <dgmo...@xxxxxxxxx> wrote in message

news:1180442852.323508.301280@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



I am a long-time VBA/Access developer but a newcomer to web services.
I have data in an Access table that I need to write to a SQL Server
table via web services. The web services developers have provided me 3
functions to do this - Initialize, which retrieves an instance ID,
Import, which is called for each row of data to be transferred, and
Finalize, which runs after all records have been transferred.

The developers are not VB guys and have not able to tell me how to
invoke these functions in my code, and my examination of the functions
leaves me clueless as to how to use them - obviously they wrap my data
in xml tags and send it to SQL Server, but I have no idea how to pass
the data to them.

I find reams of info online about creating web services, etc., but
have found nothing to help me use a service that already exists.

Any suggestions would be appreciated.

Thanks
Dave

Andrew,

I need to invoke the data transfer from within the Access application.
When the user finishes processing records within the application, he/
she needs to be able to click a button that launches code to transfer
the data from the Access table to SQL Server via the web service
functions that have been provided.

Thanks
Dave






.

Relevant Pages

  • Re: Passing an variant from classic ASP page to a .NET webservice
    ... Because my C# webservice expects an integer and classic ASP uses ... Web services are not simple AJAX, ... On the client, you need to create a POST request, and the request's body must be compliant with SOAP. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SCO unix 5.0.6 web services setup
    ... >> customer sends me requests with SOAP or XML my system accepts the ... > Axis is the choice if your program handling the web services calls is ...
    (comp.unix.sco.misc)
  • Re: Consuming a .NET WebService in VB6
    ... check the status of support for the MS Soap ... > If you want to use web services in vb6, you need to use the SOAP Toolkit. ... >> What I want to do next, is to invoke the webservice from within my ...
    (microsoft.public.dotnet.framework.webservices)
  • SCO unix 5.0.6 web services setup
    ... I need to install the "web services" deal on my unix box so that when a ... customer sends me requests with SOAP or XML my system accepts the call on ...
    (comp.unix.sco.misc)
  • RE: Get an error when post soap message
    ... you have an ASP.NET webservice and a certain client ... app which use XMLHTTP to send SOAP request to the asp.net webservice (in ... we can use some trace tools such as the Soap Tookit's Trace Utility ... | error" if the web service has some parameter. ...
    (microsoft.public.dotnet.framework.aspnet.webservices)