Solved

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

Posted on 2013-06-04
4
328 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 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

Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 threads here at EE, each comment has a unique Identifier (ID). It is easy to get the full path for an ID via the right-click context menu. However, we often want to post a short link within a thread rather than the full link. This article shows a…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

821 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