473,327 Members | 1,919 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Design Problem!!

Jay
Hello,

I have Windows Forms application which uses MS Access Database and a Pocket
PC application which uses Datasets, Iam trying to pass Datasets between
these applications using WebServices. Both these applications are shrink
wrapped so they need to perform with little user configuration

WebService/IIS is running on the computer having the Windows Application and
Pocket PC connectss to the webservice through Active Sync.

Iam trying to accomplish following task and am breaking my head over it-

1. How does the Webservice know where the MS Access Database is present. ie
How will the windows application let webservice know the location of the MS
Access database?
* I thought of registry but WebService might not have permission to read
it.
* I thought of saving an xml file in wwwroot but it could be read only.
* Web.config solution is not possible because end user is not very computer
savvy, so every time MS Access database changes its path Web.config needs to
chnage.
* Finally I thought of Web Cache. But evertime user restarts his computer
cache might get over written.
Any other workable suggestions?

2. When application starts up in the pocket pc, how will it find the name of
the host computer to get to the location of the webservice? Since the
client's computer name is not known in advance, can pocket pc application
find it other than entering the name manually.

Thanks a lot.
Jay
Nov 18 '05 #1
3 1469
1) I would go for storing the location in the web.config. You can create a
setup package that alters the web.config while installing the app. No user
interaction is needed.

2) I think you better post this question in a compact framework newsgroup...

Another question, are you planning to run web services on a desktop pc?

--
Greetz
Jan
________________
Read my weblog: http://weblogs.asp.net/jan
"Jay" <pr********@atginc.com> schreef in bericht
news:uk*************@TK2MSFTNGP12.phx.gbl...
Hello,

I have Windows Forms application which uses MS Access Database and a Pocket PC application which uses Datasets, Iam trying to pass Datasets between
these applications using WebServices. Both these applications are shrink
wrapped so they need to perform with little user configuration

WebService/IIS is running on the computer having the Windows Application and Pocket PC connectss to the webservice through Active Sync.

Iam trying to accomplish following task and am breaking my head over it-

1. How does the Webservice know where the MS Access Database is present. ie How will the windows application let webservice know the location of the MS Access database?
* I thought of registry but WebService might not have permission to read
it.
* I thought of saving an xml file in wwwroot but it could be read only.
* Web.config solution is not possible because end user is not very computer savvy, so every time MS Access database changes its path Web.config needs to chnage.
* Finally I thought of Web Cache. But evertime user restarts his computer
cache might get over written.
Any other workable suggestions?

2. When application starts up in the pocket pc, how will it find the name of the host computer to get to the location of the webservice? Since the
client's computer name is not known in advance, can pocket pc application
find it other than entering the name manually.

Thanks a lot.
Jay

Nov 18 '05 #2
I would recommend that the Windows Forms application pass the location of
the Access database to the Web Service. The Web Service can store it in the
cache. As far as restarting the computer, you can put the Windows Forms app
(or one of its friends) in the startup group, and have it pass the
information then. Of course, the Windows Forms app will have to know where
the database is, but then someone has to start this thing!

If the Pocket PC is connected via ActiveSync, you could have the Windows app
put a config file into the mirrored files on the host, where it would
automatically get synced to the PPC. The profile for the PPC would have to
include syncing files. For example, here's where some files are that get
synced to one of my PPC's:

C:\Documents and Settings\Rick\My Documents\IPAQ_3650 My Documents\Business

"Jay" <pr********@atginc.com> wrote in message
news:uk*************@TK2MSFTNGP12.phx.gbl...
Hello,

I have Windows Forms application which uses MS Access Database and a Pocket PC application which uses Datasets, Iam trying to pass Datasets between
these applications using WebServices. Both these applications are shrink
wrapped so they need to perform with little user configuration

WebService/IIS is running on the computer having the Windows Application and Pocket PC connectss to the webservice through Active Sync.

Iam trying to accomplish following task and am breaking my head over it-

1. How does the Webservice know where the MS Access Database is present. ie How will the windows application let webservice know the location of the MS Access database?
* I thought of registry but WebService might not have permission to read
it.
* I thought of saving an xml file in wwwroot but it could be read only.
* Web.config solution is not possible because end user is not very computer savvy, so every time MS Access database changes its path Web.config needs to chnage.
* Finally I thought of Web Cache. But evertime user restarts his computer
cache might get over written.
Any other workable suggestions?

2. When application starts up in the pocket pc, how will it find the name of the host computer to get to the location of the webservice? Since the
client's computer name is not known in advance, can pocket pc application
find it other than entering the name manually.

Thanks a lot.
Jay

Nov 18 '05 #3

Hi Jay,

Let me restate to clarify,
You are developing two applications, one WinForms and one Pocket PC that
both need to connect to the same database. The database will be located on
the client desktop. You also are trying to use a Web Services to connect to
the database where the Web Service is running on the desktop.

Let me first start by questioning your use of Web Services on a client
desktop that needs to be easily configured. Obviously I don't know your
exact situation, however, deploying .NET Web Services to each client will as
you know require IIS to be setup and configured. This alone sounds to
increase the complexity for end users and for the most part(in my opinion) I
would say IT would not want IIS running on all the end user desktops.

Too the questions:
How does the Web Service know where the database is?
In this situation, I would suggest the web.config. You could utilize the
Web Cache to facilitate a slightly faster lookup of the connection string,
however, the cache needs to still be loaded from some place. Again the
web.config should suffice. The problem I assume you are running into is
that you are having the WinForm directly conect to the database and the
PocketPC connect to the Web Service thererfore having to manage the database
connection string in two places.

One option is to have the WinForms app point to the Web Service as well.
However, this may not give you the performance you are looking for.
Another option is build a single Data Layer and point the Web Service to
that Data Layer as well as the WinForm app.

In the end, (with out specific knowledge of your problem) I would suggest
not using a Web Service and connecting the PocketPC directly to the database
through ActiveSync.

Now if this was a Server based solution my recommendations would be
different, and most likley include Web Services. The great thing about
using a web service is you would be able to sync the PocketPC database over
wireless.

Btw- You never mentioned how you were storing the data on the PocketPC. You
mentioned Datasets, however, datasets are not going to help you when the
PocketPC is off unless you are planning to serialize them. You may want to
consider using SQL CE on the Pocket PC and MSDE on the Desktop. If you do
this you can leverage the built-in replication features.

Let me know if you need anything else,

Tom Krueger

"Jay" <pr********@atginc.com> wrote in message
news:uk*************@TK2MSFTNGP12.phx.gbl...
Hello,

I have Windows Forms application which uses MS Access Database and a Pocket PC application which uses Datasets, Iam trying to pass Datasets between
these applications using WebServices. Both these applications are shrink
wrapped so they need to perform with little user configuration

WebService/IIS is running on the computer having the Windows Application and Pocket PC connectss to the webservice through Active Sync.

Iam trying to accomplish following task and am breaking my head over it-

1. How does the Webservice know where the MS Access Database is present. ie How will the windows application let webservice know the location of the MS Access database?
* I thought of registry but WebService might not have permission to read
it.
* I thought of saving an xml file in wwwroot but it could be read only.
* Web.config solution is not possible because end user is not very computer savvy, so every time MS Access database changes its path Web.config needs to chnage.
* Finally I thought of Web Cache. But evertime user restarts his computer
cache might get over written.
Any other workable suggestions?

2. When application starts up in the pocket pc, how will it find the name of the host computer to get to the location of the webservice? Since the
client's computer name is not known in advance, can pocket pc application
find it other than entering the name manually.

Thanks a lot.
Jay

Nov 18 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Michael Olea | last post by:
Here is a design problem I ran into this am - and I have cleaned the bathroom, scrubbed toilet sink and tub, windexed all glass, mopped the floor, and vacuumed the house - no dice, the problem is...
3
by: Merlin | last post by:
Design Problem =============== Would appreciate any help or suggestion on this design issue. I have spent a great deal of time and effort for an elegant solution but it seems I am not getting...
11
by: Tamir Khason | last post by:
I have VERY BIG object (>2G) serialized and I'm loading it into some object. In client's site I have P4 3G/512Mb computer where the application running. In the computer the page file is 3G. But...
19
by: Chocawok | last post by:
Some of the classes in my app are graphical. To encapsulate the graphical side of things I had created a class called "sprite" which holds a bit map and knows how to draw itself etc. The...
2
by: Kalpesh | last post by:
Hello, I am facing a design problem here & need your expert design advice on this. Scenario: I have a class called Vendor - which has several simple attributes like Name, Address etc Now,...
1
by: Grabi | last post by:
Hello. I'm using SQL2000, and I have a design problem. I know that every time I make a primary key, sql server makes it by default a clustered index. Since I have a large composite key in the table...
5
by: Leslaw Bieniasz | last post by:
Hello, I have the following OOP design problem. I have a base class designed as an element of a list, let's say: class A { public: // some stuff
6
by: dragoncoder | last post by:
Hello experts, This is actually a design problem which I want to solve using c++. I have the following class. class Animal { public: virtual void run() { uselegs(); }
0
by: koren99 | last post by:
Hi, i am having trouble solving a design problem i'm sure is common, and wanted some help. for berevity i'll skim the problem to a smaller example. I have a design where a base class is...
2
by: forums_mp | last post by:
Facing a design problem here and I'm not sure how to solve this. The system consists of bi-directional communication between a subject communicating with two (at least for now ) listeners. ...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.