Solved

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

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

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

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…
Configuring Remote Assistance for use with SCCM
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

751 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