Re: Need starting advice...

Gregory,

You are suggesting a subscription model, is that correct? I've been considering that as well. In the books, it is stated that ADO.NET captures not just the data, but the relations as well, however in looking at the XML schema, I find no indication of this -- I am guessing it captures relations based only on the SQL used to populate the dataset, not the relations from the underlying tables... For instance, a single table select has no relation information, but a JOIN select would contain the relationship info in the schema??


Cowboy (Gregory A. Beamer) wrote:
1. Set up MSDE (SQL Server 2000 free) or SQL Express 2005 (this is fine as long as you do not use the SQL 2005 features) on the laptop. This is your primary data store. Thsi covers persistence. You could also use CSV files, XML files, etc., but SQL Server is useful at a later step.

2. Look for articles on mutli-homing of a computer. They will provide the easiest method of having the computer know where it is at and only reply when hooked up on the correct network. The goal here is having the computer know where it is at and then try to connect. The main goal here is only attempting to synch when you know you are on the right network. It is not mandatory, but certainly makes things easier, as you do not have to multi-thread the application to get work done while it is looking for something it will never find.

3. Even if #2 is not completed, you will have to see if you can connect to the server. If so, syncronize the data. Most likely, you will need a two-way synch. Transactional replication works well for this (SQL Server specific). If not, you will have to upload information and then grab a complete snapshot for the laptop.

In many ways, I prefer SQL Express to MSDE, even if your main data store is SQL Server 2000, as it has a few nice features that can help you with other aspects of programming. I am also not completely sure MSDE can easily participate in a synch, so Express may be better here.

.

Relevant Pages

  • Re: Is There a Client/Server Version of Access ?
    ... as there's no central process interfacing with the data store that ... There's also the newer SQL Server Express, ... MySQL has nothing to do with Access. ... And if you do Open Licensing, it's as easy as it can get. ...
    (comp.databases.ms-access)
  • Re: Question about data stores
    ... Does SPS support the assignment of physical locations to ... > to use either SQL Server or MSDE. ... >> What's the way to specify the location of the content of a data store? ...
    (microsoft.public.sharepoint.portalserver)
  • There is a problem with your selected data store
    ... i found the folloling error message when tried to administer the login ... There is a problem with your selected data store. ... i hav SQL server 2000 installed on my system. ... do i hav include the connection string just as sqlConnection String ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Best Approach Based On Current Skills
    ... > You can store the data in sql server, or store the data in ms-access. ... > out web pages to each user, and that web server would also connect to your ... > data store. ...
    (microsoft.public.access.gettingstarted)
  • Re: Trace Log - Failure to capture known SQL activity
    ... Is it SQL Server 2000 or 2005? ... It captures ordinary user traffic just fine. ... The problem and my basic trace log settings are listed below. ... Windows Server event logs captures an unauthorized administrator ...
    (microsoft.public.sqlserver.security)