ODBC or not?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Home - 26 Feb 2004 06:33 GMT

Hi,

it is possibe to place the DBF, CDX and FPT files on the server while
executing the main program as a client from different pc's. These clients
can access the database through odbc. Another option is to place all files
only once on the server and let all the pc's connect to it directly.
What arguments are there do decide how to create a stable client server
application?

Thnx.

Rogier

Reply to this Message

Cindy Winegarden - 26 Feb 2004 17:03 GMT

> it is possibe to place the DBF, CDX and FPT files on the server while
> executing the main program as a client from different pc's. These
[quoted text clipped - 3 lines]
> What arguments are there do decide how to create a stable client
> server application?

Hi Rogier,

I keep my data files on a file server and access them through my apps on
different PCs all the time. I do this natively with a VFP front end - I
don't use ODBC.

There is no way you can have a true "client-server" app with VFP tables,
even if you access them via ODBC. As long as you've got a VFP front end
you're far better to access them directly through VFP. If you're accessing
the tables from a VB front end, for example, then of course you'll need to
use ODBC.

Signature

Cindy Winegarden MCSD, Microsoft Visual FoxPro MVP
cindy.winegarden@mvps.org www.cindywinegarden.com

Reply to this Message

Igor Korolyov - 27 Mar 2004 16:01 GMT

Hi, Cindy!
You wrote on Thu, 26 Feb 2004 12:03:48 -0500:

[Sorry, skipped]

CW> There is no way you can have a true "client-server" app with VFP tables,
CW> even if you access them via ODBC.

Not with ODBC, but easily with COM+ or WebServices - just write your own data access components, register them on server and access data only through them - it _will_ _be_ _real_ C/S!

[Sorry, skipped]

Signature

WBR, Igor

Reply to this Message