Newbie converting app to dot net - Architecture questions.

[Eric]

Hi, I'm about to start migrating a system and have some questions. I'm just
starting with dot net, so some may be silly. . .

My current application is a vb6 front end and an access database split into
an app.mdb and data.mdb. We have been using pocket access for pocketPC data
entry. We only have several users, rarely concurrently. Most data is input
by one or more pocketpc devices. I'd like to run this on a new XP home/pro
box, but don't really want to spend the money for sql server or IIS, etc.
Really, I'm doing this to update the handhelds, as the pocketaccess is
obsolete.

I will probably install a wi fi network.

I'm thinking of migrating the data from access to sql server, and attach it
to the app.mdb, theoretically, I can continue using my vb6 app and app.mdb
this way - right? Maybe I would update this to .net at a later time. Do I
need SQL server for this, or just the desktop edition?

The handheld is more of a question for me. Can I use SQLCE with the desktop
edition of SQL server? License cost? Should I use web services?
Remoting? Do I need IIS? Does that mean I need Windows Server? I am not
anticipating high load or a lot of users. The max for the foreseeable
future is really 3 users. . . and not much data throughput.

Comments on good books and/ or sample code to get started? I assume I will
get VS.Net Pro?

Thanks.

e

 

[Cor]

Hi Eric,

A lot of questions, luckely easy to answer.

IIS is a part of XP pro. (not from home)

For your database have first a look at this

http://www.microsoft.com/sql/msde/default.asp

I hope this helps?

Cor

 

[Eric]

IIS is a part of XP pro. (not from home)

That;s the full version? Great!

For your database have first a look at this

http://www.microsoft.com/sql/msde/default.asp

I hope this helps?

Thank you for the response. I do plan on using MSDE. Do you know if I can
use the handheld extensions SQLCE?

Thanks in advance.

e