XDSL+FoxPro DB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mike Hunt - 13 Aug 2003 09:22 GMT

Hi Group,

I have a situation here where my application is running at client's site and
the FoxPro database (*.DBC) is remotely located on a host server and I have
an XDSL Connection as well. Can any one tell me what is the best way to
access the DBC from my application. I know it is kind of network related
question. I may have somehow to map the drive on the server into the
client's machine (if it is a stand alone) or use ODBC and do the same
probably with more effectively (possibly). What is the common way of
Client-Remote Server Application when the FoxPro Front end is up running on
the Client and to access the FoxPro Native DBC to the remote server?

Any experiences to share?

Thanks

Reply to this Message

Mike Hunt - 13 Aug 2003 10:53 GMT

Just to add my this query.....I am thinking that VPN could be a possible
solution to really map the drive and point the DBC on the mapped drive over
Firewall and IP\share?

Any better solution?

> Hi Group,
>
[quoted text clipped - 11 lines]
>
> Thanks

Reply to this Message

Eric den Doop - 13 Aug 2003 14:55 GMT

Hello, Mike!

For security reasons, VPN is a great solution. I think that querying and
modifying data over a DSL line is still very slow. Consider other
alternatives such as:
- web services
- Terminal Server

Signature

Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

Reply to this Message

PAul Maskens - 21 Aug 2003 17:34 GMT

> Hi Group,
>
[quoted text clipped - 9 lines]
>
> Any experiences to share?

Don't do that., it hurts !!
Any table access across a WAN (even ADSL, SDSL) is going to be slow.

What we are doing is using a Terminal Server where the users run the apps.
That is linked on a LAN (in our case 1GB over copper) to the Data server.

Then all the users access via LAN (10MB) or WAN (2MB VPN) and use the Remote
Desktop Client to connect to the server. They have an image of the server
screen on their PC, and they get LAN 1GB speeds, but only have to send the
screen redraw, keyboard and mouse commands across the network.
Works well for us.
We run Belgium, Netherlands, Germany Ireland and UK all out of one computer
room with a bank of terminal servers and data servers (per country) all over
two 2MB pipes.
We use Watchguard firewall at each end of the connection which provides the
VPN link between countries.

We also allow staff to connect to the UK VPN from home via their XDSL or
Cable connections to work from home.

I abuse the system <g> and run my desktop XP machine using Remote Desktop
from my laptop wherever a I happen to be.
I was even logging in, doing email, answering newsgroup messages, from the
Tech *Ed conference in Spain via Microsoft's wireless LAN!

Reply to this Message