Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Lock out a VFP 8 database from other apps or VFP
Message
From
19/09/2003 01:56:04
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00829814
Message ID:
00830569
Views:
28
Try a free database server. I was in the same situation , but we wanted the switch to a client-server solution because frequent data corruption issues.
At that time I was considering MySQL, Postgres and Firebird SQL. MySQL is very fast but lacks transactions, stored procedures, triggers, foreign keys constraints. Postgres is very advanced, Oracle like, database server but it didn't had native windows version (I don't know what the situation is now).
So I downloaded and tested Firebird SQL, based on open source Interbase 6, I liked it and I use it now.
It is only 3M download (the documentation is much more - about 10M) but has a lot of features: stored procedures and trigger support, multi versioning transaction support (I heard that SQL Server will have this only in 2004) , foreign key constraints, domains, online backup, database shadowing. You can return record sets from stored procedures , join record sets returned by stored procedures, subselects, custom exceptions, database events,....
And, if something goes wrong or the open source project die, I have the Borland Interbase server as a backup solution (check it too, is much cheaper than SQL Server and easy to administer)


>SQL-Server is also being evaluated but the cost may be prohibitive to the project hence the research for using the VFP database considering VFP will be the front-end regardless of the database.
>
>The reason for the question is because the DBF format is so well known and accessible by many products other than VFP. And that's the point, I need good code to prohibit that from happening.
>
>Thanks,
>Steve
>
Previous
Reply
Map
View

Click here to load this message in the networking platform