Solved

Running a FoxPro based Database via a router to router VPN connection across 2 domains

Posted on 2006-11-06
5
413 Views
Last Modified: 2010-04-12
First off, let me start off by stating, I am by no means an expert with networks, but have been asked over the past 4 years to care for our 2 separate networks (at 2 locations). My primary job is Graphics and Customer Service. With that said, recently we decided that the 2 locations should talk via a VPN connection so that we can access the files from both locations. This has been a very long process (3 months) and finally the VPN is up and we have just in the past couple of days been able to establish trust between the 2 domains.

The next step is....we want to be able to run the Accounting Software, which is a FoxPro Based Database. To make this easy to follow, let's say our two locations are LA and Sacramento. The files for the Accounting software are located in LA and we at Sacramento want to be able to run them. I am being told by the people who made the Database, that we have to run it off a mapped drive. In Sacramento, I have mapped the drive to the same location and same drive letter, as we do down in LA. And I have created a shortcut on my desktop to run this software targetting the mapped drive and required files.  We have been successful at getting the program to run but what normally takes 20 secs is now taking 10 mins to even load. And then to run anything else it locks up the system.

Any suggestions would be helpful. Thanks!!
0
Comment
Question by:Deluxepackages
  • 3
  • 2
5 Comments
 
LVL 77

Expert Comment

by:Rob Williams
ID: 17886260
Unfortunately the last thing you want to run over a VPN is an application making use of a database. There is so much "chatting" going on that the performance is terrible, and further more it can result in corrupt data. The best way to deal with this is to connect to a computer in LA (where the data resides) using remote desktop or a similar utility, over the VPN, and run the accounting application in this way. Doing so means only the screen changes are transmitted across your VPN, and performance is usually great. If you are not familiar with remote desktop please advise and we can provide the necessary details.
http://www.microsoft.com/windowsxp/using/mobility/getstarted/remoteintro.mspx
0
 

Author Comment

by:Deluxepackages
ID: 17891011
I have actually done something similar to this by using PC Anywhere to get us access, but this is not the solution we want. 1) We have dificulties printing, 2) File export and transport is dificult, but the reason it makes it not a solution is 3) only one person can be on the system at a time. We need to have 3+ people accessing the database at the same time.  Any other suggestions.
0
 
LVL 77

Accepted Solution

by:
Rob Williams earned 500 total points
ID: 17891135
Terminal Server would be the only other option I could suggest. Basically the same solution but allowing multiple simultaneous users. Not a cheap answer though.

If you want to do some tinkering, different articles claim to have it working. Below is a link explaining how to allow a second user to connect to an XP machine using remote desktop. Includes a link to the required Terminal Server file for download. good luck:
http://sig9.com/articles/concurrent-remote-desktop
http://winfaq.msterminalservices.org/faqs2.cfm?id=460&category=2&sortby=date
Helpful comment by one successful "tinkerer"
It worked perfectly after I worked around one issue...I had to modify the .reg file. Instead of "ControlSet001" I had to change the path to "CurrentControlSet". After that, it worked like a charm! Thanks!
from: http://www.experts-exchange.com/Applications/Q_21577223.html?query=concurrent-remote-desktop&clearTAFilter=trueEE

One other option which I have not tried is a third party utility to allow up to 21 users:
http://www.thinsoftinc.com/
0
 

Author Comment

by:Deluxepackages
ID: 17891270
Thanks RobWill, I will look into these articles, but I will more likely end up going to the Terminal Server. I had already thought that was the path that I might have to take, but was hoping there might be a cheaper path I was over looking. Thanks again.
0
 
LVL 77

Expert Comment

by:Rob Williams
ID: 17891315
Thanks Deluxepackages,
The last option from ThinSoft looks interesting. I think you would be limited by the hardware with XP, but 3 users might work fine with a GB or more of RAM, and $300 sounds pretty good. I don't know if they have a demo version though. It would be nice to test first.

Good luck with it.
--Rob
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Suggested Solutions

Like many others, when I created a Windows 2008 RRAS VPN server, I connected via PPTP, and still do, but there are problems that can arise from solely using PPTP.  One particular problem was that the CFO of the company used a Virgin Broadband Wirele…
If you use NetMotion Mobility on your PC and plan to upgrade to Windows 10, it may not work unless you take these steps.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

746 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now