Solved

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

Posted on 2006-11-06
5
425 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: 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!

Question has a verified solution.

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

Juniper VPN devices are a popular alternative to using Cisco products. Last year I needed to set up an international site-to-site VPN over the Internet, but the client had high security requirements -- FIPS 140. What and Why of FIPS 140 Federa…
Secure VPN Connection terminated locally by the Client.  Reason 442: Failed to enable Virtual Adapter. If you receive this error on Windows 8 or Windows 8.1 while trying to connect with the Cisco VPN Client then the solution is a simple registry f…
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…

623 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