[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

URGENT: How can I create this Application need

Posted on 2006-05-09
11
Medium Priority
?
268 Views
Last Modified: 2010-04-23
I have this project (a POS) that has work station on the same site and some on a remote location.
This project has been writen in VS2005 (VBNET) (SQL2000 Server Main Location) (Access2003 Local MDB)
What i'm looking for is a way to connect locally and remote to the SQL server to upload info and download info from the work stations VIA internet and Intranet. Just some guide lines will help me.
From the Remore sites I need to get and update info to SQL server. I do not have time to rewrite this on ASP. So the must short way will be appriciated.
0
Comment
Question by:ofern01
  • 6
  • 4
11 Comments
 

Expert Comment

by:peterdevadoss
ID: 16641593
You may connect the report location by phone line either by dialup or dsl connection.

Once you connected to the remore pc through phone line, you will be able to see the database at the remote network.

This way, you dont need much changes in your coding.

0
 
LVL 9

Expert Comment

by:sk33v3
ID: 16642050
Ok let me make sure I understand what you need. You have an application(point of Sale) which is using Access as its backend. You want the local POS system to at some point connect to a remote server and synchronize its database with the SQL Server. Is this correct?
0
 
LVL 1

Author Comment

by:ofern01
ID: 16642391
That is correct
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Author Comment

by:ofern01
ID: 16642401
Actually I just want To send the MDB over to the server side, place it on a directory so that the server app will process it locally and that will be a faster solution.
0
 
LVL 9

Expert Comment

by:sk33v3
ID: 16642455
Ok, well what you will want to do is create a last sync date, or go off the last file uploaded, and synchronize all the additional data. The easiest way to accomplish this is to add a datecreated field that can not be changed. Also add a field called DateChanged. These to fields change whenever information is added or changed then server side you look for any record that has the date created tag after the last sync and then you will want to update any fields that have the DateChanged variable more recent than the last upload. Does this make sense? Or did you need help with the uploading only?
0
 
LVL 1

Author Comment

by:ofern01
ID: 16642537
Sorry to mislead you.
What I'm looking for here is not how to sync. That I allready have.
I need the following:
From the Remote Station,How do I Login to the server and place a file on the server, at the same time I will be picking up a file from the server to the remote station
0
 
LVL 9

Expert Comment

by:sk33v3
ID: 16642625
hmm, well you can do this in one of a few ways, the easiest and quickest would be Via FTP and using the default built in FTP server in your windows server, however this does lose some of the power. You could try and create a web service that receives uploaded fiels but this increases in complexity and finally the most complex solution would be to basically create your own FTP server. Now Visual Studio does have Class libraries that you can consume that can handle most of the work but it is probably by far the most time consuming and complex of all of the solutions. The easiest way as I stated earlier is using Plain old FTP and having the server check the directories every so often to see if a new file has come in.

Now after having stated all that above you could attempt to make your own transfer protocol but I doubt that is what your looking for.
0
 
LVL 1

Author Comment

by:ofern01
ID: 16642686
The web Service looks like the must appropiate way right now. Do you know an article or sample that I can use as a guide?
0
 
LVL 9

Expert Comment

by:sk33v3
ID: 16642720
Try this article
http://www.devarticles.com/c/a/VB.Net/Creating-A-Windows-Service-in-VB.NET/

There are several books that do have chapters devoted to these types of Items.
0
 
LVL 9

Expert Comment

by:sk33v3
ID: 16642730
Woops sorry wrong window. That is on servers not webservices.
0
 
LVL 9

Accepted Solution

by:
sk33v3 earned 2000 total points
ID: 16642739
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Since .Net 2.0, Visual Basic has made it easy to create a splash screen and set it via the "Splash Screen" drop down in the Project Properties.  A splash screen set in this manner is automatically created, displayed and closed by the framework itsel…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
Is your OST file inaccessible, Need to transfer OST file from one computer to another? Want to convert OST file to PST? If the answer to any of the above question is yes, then look no further. With the help of Stellar OST to PST Converter, you can e…

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question