Jim DeMarco
Jdemarco at hudsonhealthplan.org
Wed Dec 14 07:00:51 CST 2005
The confusion seems to be on the definition of the client end. By client I'm referring to the SQL DB hosted on their server not a db on a local PC. We'd like them to be able to access their data as if we were hosting the db. I'm not clear on why that's different. If I have a web site and I host the database users can log on and access data and do data entry chores. What's the difference if the db is hosted elsewhere and I point to it dynamically based on user log on? There are two required components to this app. 1 - defining files (or maybe data streams) for download/upload, 2 - sending files/data. The ability to provide some data entry tools is a would be nice but if I can do the file/data stuff this should be possible. Someone had suggested .NET remoting which may be an option in this case. Jim D. -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Michael Maddison Sent: Tuesday, December 13, 2005 7:22 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Is this possible (X-posted) Jim, I've just re-read your email and realised what you appear to want is probably not straightforward. Lets see if I got you right this time... The client logs onto you shell site. Your site then connects to the client PC, then the client db, pulls data back up to the web server and displays to the client? Even if this is possible (I have doubts) isn't it going to be very slow? Security would be a nightmare IMO. Maybe replication might help? Much better to have a dedicated db for each client on your db server. There are plenty of companies using this model already. cheers Michael M Michael, >> let the WS and Client app do the DB work Exactly what I was thinking. I just need to be able to tell the WS were the databases are for each client location (from the web interface). But you do believe that possible. That's good news. We'd also like a UI as some local gov't agencies have limited IT resources so they'd have to have write access to the data but if the above is true then this is likely to work as well. Thanks, Jim DeMarco -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Michael Maddison Sent: Monday, December 12, 2005 6:04 PM To: dba-vb at databaseadvisors.com Subject: Re: [dba-VB] Is this possible (X-posted) Hi Jim, Sounds possible to me. In fact this is what web services are for IMO. One way I would do it is... Client app connects to WS, gets authenticated. Client app calls WS method for list of available fields, Client chooses which fields are required, pass back to WS, WS stores in your DB, client stores local copy. Client calls WS method to return data. Client calls WS method to upload data. Not sure you want to directly access there db's, let the WS and Client app do the DB work. cheers Michael M DDI Solutions Pty Ltd michael at ddisolutions.com.au Bus: 0260400620 Mob: 0412620497 www.ddisolutions.com.au -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Jim DeMarco Sent: Tuesday, 13 December 2005 3:08 AM To: VB List (E-mail); AccessD (E-mail) Subject: [dba-VB] 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". ************************************************************************ *********** _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com ************************************************************************ *********** "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". ************************************************************************ *********** _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com *********************************************************************************** "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". ***********************************************************************************