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

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!
Eduardo FuerteAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
pcelbaConnect With a Mentor Commented:
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
 
pcelbaCommented:
DBC will not help in this case. DBC just means 3 more files for you.
0
 
Eduardo FuerteAuthor Commented:
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
 
Eduardo FuerteAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.