Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Access
Message
De
22/07/1998 06:54:42
 
 
À
22/07/1998 01:57:35
Marcial Eleazar
Royal Victorian Institute For the Blind
Melbourne, Australie
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
Divers
Thread ID:
00120033
Message ID:
00120075
Vues:
15
>I would like to access old DBF (Foxplus Tables) on a UNIX server at
>a different location on another server. My problem is it takes a long
>time to access the data over 128K connection. Is there any other way
>to make it faster.
>

Short of implementing an ODBC-compliant server on the Unix box that works with .DBF files at the server end, probably not. If you're doing repeated accesses of the data and it's being used read-only (ie your app at the different location doesn't update the files, but repeatedly reads against the data, especially if you're opening and closing the remote .DBF a lot) you'll probably get significantly better performance by copying the table from the remote server to a local drive and using the local copy.

>How do I go about simulating a client/server access where I just want
>to get the results?

You can use parametized views, switching from local views serviced directly by VFP to remote views serviced by an ODBC-compliant server application when you have a server to go against.

>I've read that Visual FoxPro is a Client/Server
>application what do I need to do, so that I can access the data from 3
>different locations and server.
>

VFP can work in a client/server environment, but it is dependent on a database server, not a file server, to provide access to the data. Both file servers and database servers operate in a client/server fashion; one machine provides access to its resources (the server) for a remote or out-of-process requester (the client.) The type of server determines the type of interface to the server resources provided to the client. A file server makes files available to another system as if the files were located locally; it accepts traditional file operations (read/write/seek) against the files, but the client is responsible for doing higher level operations against the file. A database server makes the content of the database accessible not via traditional file-level accesses, but through a SQL interface, accepting SQL commands and where appropriate returning result sets to the client. IOW, a connection to a file server does not equate to C/S database access.

Ed
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform