Solved

Using DBC in a server folder could facilitate in someway the network access ?

Posted on 2013-06-04
4
331 Views
Last Modified: 2013-06-07
Hi Experts!

Using DBC in a server folder could facilitate in someway the network access ?

My system is using free .DBF tables and have been planned to run in network, but just now the first user that is asking to use it in network.

In order to make it better run in a network I'm planning to put all the tables in a DBC that will remain in the server folder. Is it a better idea than make it remain as free .DBF?

Thanks in advance!
0
Comment
Question by:Eduardo Fuerte
[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
  • 2
  • 2
4 Comments
 
LVL 42

Expert Comment

by:pcelba
ID: 39220593
DBC will not help in this case. DBC just means 3 more files for you.
0
 

Author Comment

by:Eduardo Fuerte
ID: 39222777
So, there is that any special detail in your message, days before, that I miss ?

"VFP 9 SP2 is still the major tool to me which allows to develop both desktop and client-server apps (yes, VFP can serve you as a server with no license fee). "

Sorry the insistance!

Thanks!
0
 
LVL 42

Accepted Solution

by:
pcelba earned 500 total points
ID: 39225005
That's OK. You've been asking for DBC and I've ansvered very shortly...

DBC advantages (sometimes questionable) are:
- long field names possibility
- database events
- triggers
- stored procedures
- etc. more info: http://msdn.microsoft.com/en-us/library/w87s2tx4(v=vs.80).aspx

DBC disadvantages are:
- you still have to use DBF, FPT, and CDX files
- another layer of possible problems

You don't need to usee DBC when you are planning to port your app into network.

If you need to port your app into multiuser environment then you have to change a few things: http://msdn.microsoft.com/en-us/library/h6hhascz(v=vs.80).aspx
Newest MS operating systems have certain problems with this approach but appropriate settings may help. You may find more details when you search for SMB2 and oplocks.

To create Visual FoxPro app as client-server app requires even more changes: http://msdn.microsoft.com/en-us/library/aa690493(v=vs.71).aspx (you'll need to decide about the server side - MS SQL, MySQL etc.). Many books exist.

And to use FoxPro at the server side requires to use VFP app as COM server: http://msdn.microsoft.com/en-us/library/ms917477.aspx  which almost means to start writting the app from a scratch.

Some links are for VFP 7 but they are valid for VFP 9 also.

We are using VFP as COM server for years. 150 clients are working simultaneously without problems. We don't need reindex, we don't have data corrupted due to the network failure etc.

And that's not all... Terminal server or Remote desktop solution is also possible...

So for you is the easiest way to try file server in multiuser environment (without DBC). You just have to solve situations what to do if two users will access one data record simultaneously.
0
 

Author Closing Comment

by:Eduardo Fuerte
ID: 39228649
Thanks for your explanations!
In my case I just used the basic network functions and since the use will not be so massive, it could attend well.
But it's good to know these possibilities. I'm carefully reading .
0

Featured Post

Industry Leaders: 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

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
This article is written by John Gates, CISSP. Gates, the SNUG President-Elect, currently holds the position of Manager of Information Systems at Lake Park High School in Roselle, Illinois.
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Suggested Courses

617 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