The Best Known Way - Windows App to Web DB

  • Thread starter Thread starter Tom Carter
  • Start date Start date
T

Tom Carter

Can anyone suggest the best known way to connect a windows app (vc#)
to a database (msaccess) stored on the web? I'd like to make inserts
from my windows app..

Thanks in advance,
Tommie C-
 
I'm not sure of the configuration that you have...so that can be a difficult
question. One easy solution is to build a Web Service on the web server
that can talk to the DB. Then, just have your windows app talk to the web
service.

Is this DB behind a firewall?
 
A webservice can (and in my case does) queries, inserts, and updates MS
Access databases.

The windows application can connect to the webservice.

Inserting and Updating records in the database was a bit of a challenge, I
had never heard (nor read) of webservices doing so... But I was determined!
I made public functions that returned integers indicating how many rows were
affected (simply return the integer value of ExecuteNonQuery)

Works really well, I have people uploading soccer tournament schedules to
the website, they can add change or delete any game in their database
through their windows app.

Severin
 
Create a web service on the web machine that pulls data for you. Either that
or you will have to use a UNC path to the machine, which is difficult if it
is Internet (not Intranet).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************
 
Back
Top