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



All you need to do is create a WebService project in VS.NET and create 3
different WebMethods that perform the tasks you've indicated. You don't
need to do anything on the Access side (although I really wouldn't be using
Access for web site storage/web service access).

Then a front-end ASP.NET project can be made that simply adds a Web
Reference to your Web Services assembly. VS.NET takes care of the rest.

-Scott


"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: Webservice SQL logon fails on production IIS server
    ... Do you have the two machines in one domain? ... Martin Kulov ... Anonymous access is not enabled on any of> the intranet IIS web services. ... They also work correctly when the services are> hosted on an IIS server on the same machine as the SQL Server. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: Webservice SQL logon fails on production IIS server
    ... authentication for SQL Server authentication because the stored procedures ... The web services work correctly when they are hosted ... hosted on an IIS server on the same machine as the SQL Server. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: HTTP endpoint WSDL fails to be created; wsdl does not exist (S
    ... IIS is not involved with nor is it needed for web services set up in SQL Server 2005. ... SQL Server works directly with http.sys to set up the endpoint. ... In general you probably wouldn't have IIS running on the server that was running SQL Server, ...
    (microsoft.public.sqlserver.setup)
  • Re: Database app for xda II
    ... We have a whole SQL Server CE section here ... data transfers over web services and he's got some great articles which are ... > We have a .net database app with MS Access backend running in house over a ... > windows 2000 server network. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Sql Server 2005: Get a list of all configured Web Services in the "Object Explorer"
    ... > Studio" where i can see these Web Services. ... Hm, when I think of it, I might have seen an Endpoints node under Security, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server SP3 at ...
    (comp.databases.ms-sqlserver)

Loading