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

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" <dgmoore@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



.

Relevant Pages

  • Re: Newbie question - how to use Web Service function in Access
    ... Have the developers given you a WSDL file? ... information you would need to access the webservice. ... The web services developers have provided me 3 ...
    (microsoft.public.dotnet.framework.aspnet.webservices)
  • Re: How to create virtual webservices?
    ... I want to create a servlet or something similar by which im able to create ... Lets say i would like to create a webservice with a method called 'getDate' ... i mean that i will create the wsdl file dynamically, ... That would defeat the purpose of web services. ...
    (comp.lang.java)
  • Re: How to create virtual webservices?
    ... This could be done by making a wsdl file and via a wizard in some java tool make a real webservice. ... The servlet should be published to a server and the behaviour cant be changed without compiling the class again and publish again. ... By this i mean that i will create the wsdl file dynamically, when a client requests for that and i would dynamically construct the soap response, when the client makes a request on my method. ... That would defeat the purpose of web services. ...
    (comp.lang.java)
  • Re: How to create virtual webservices?
    ... I want to create a servlet or something similar by which im able to create ... Lets say i would like to create a webservice with a method called 'getDate' ... i mean that i will create the wsdl file dynamically, ... That would defeat the purpose of web services. ...
    (comp.lang.java)
  • Re: Newbie question - how to use Web Service function in Access
    ... You'll have to make the SOAP Requests and process the SOAP Responses ... Have the developers given you a WSDL file? ... I have data in an Access table that I need to write to a SQL Server ... The web services developers have provided me 3 ...
    (microsoft.public.dotnet.framework.aspnet.webservices)