Solved

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

Posted on 2013-06-04
4
319 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
  • 2
  • 2
4 Comments
 
LVL 41

Expert Comment

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

Author Comment

by:Eduardo Fuerte
Comment Utility
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 41

Accepted Solution

by:
pcelba earned 500 total points
Comment Utility
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
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

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…
In this article, you will read about the trends across the human resources departments for the upcoming year. Some of them include improving employee experience, adopting new technologies, using HR software to its full extent, and integrating artifi…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now