[AccessD] Is this possible (X-posted)

<<<
The question is: Can I do this via web services?
>>>
No.
And yes - I mean if you local PC will have Web Server with exposed to the
Outer World Web Services then these Web Services can communicate with
central web server's Web Services. But such system architecture would look
weird to say the least...

<<<
That done, can I then create data entry forms against their local copy of
the apps database?
>>>
You can export/import data using Web Services - that's clear.

The rest sounds unclear - you wanted your users to connect to the Web
Server, pass their ID and then Web Server's application use data entry forms
generated on Web Server to access user's local data via user's local Web
Server's Web Services?

Looks confusing but probably doable.

Why not have data entry forms running in local application and use data
export/import via Web Services?

Do you mean you wanted to have one Web Server with WebServices and one
ASP.NET application running on your server, and connecting to the local PCs'
database via "something like Web Services"?

Shamil


----- Original Message ----- 
From: "Jim DeMarco" <Jdemarco at hudsonhealthplan.org>
To: "VB List (E-mail)" <dba-VB at databaseadvisors.com>; "AccessD (E-mail)"
<AccessD at databaseadvisors.com>
Sent: Monday, December 12, 2005 7:08 PM
Subject: [AccessD] Is this possible (X-posted)


> dba-VB
> AccessD
>
> List,
>
> We have a VB/SQL app that we are actively marketing to other health plans
and county social service agencies that handles enrollments into Medicaid
and other government funded health programs.  I have a need to transmit the
apps data electronically from a health plan to a county agency.  Yes we can
simply FTP a file and let an agency pull the data down but it's not quite
that simple.  Different agencies have different needs for the data (some
have IT resources, some don't, some need data input to send data back to
plan some don't).
>
> My vision is a web portal where the county can define what data the plan
should send them and define a file of what data they'll send back to the
plan. My app should read the file and generate the appropriate export file
and import data correctly based on the county's export (if any).
>
> Using .NET technologies I'd like the portal to also have the ability to
connect to the local copy of my app's database for authentication and data
access.  The question is: Can I do this via web services?  Can a user log on
to my portal passing me a site ID so I know where their local database
resides for authentication?  That done, can I then create data entry forms
against their local copy of the apps database?
>
> We'd rather not host all data here (competing plans may use the app and
probably wouldn't care for that arrangement!)
>
> Hopefully this isn't too confusing and someone can enlighten me.
>
> TIA,
>
> Jim DeMarco
> Director of Application Development
> Hudson Health Plan
>
>
>
>
>
****************************************************************************
*******
> "This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged.  If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited.  If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message.  Thank You".
>
****************************************************************************
*******
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com