[prev] [thread] [next] [lurker] [Date index for 2003/11/12]
*This* one continues to cause me many headaches and provokes the desire to kick someone in the head. As I may have mentioned, I use databases comprising Paradox tables, accessed through the Borland Database Engine. The BDE's approach to file locking is nothing if not annoying. When it wants to lock something (table, record, whatever), it creates two files in the same directory as the table, PARADOX.LCK and PDOXUSERS.LCK. These reference a third file, PDOXUSERS.NET. In order to share files among processes or computers, all three of these files must be visible to all computers. But PDOXUSERS.NET usually lives in C:\, so it's a different file for each computer. Gah. But that's okay; it's configurable. I can change the location of that file in my program, so each department can have its programs all sharing the same PDOXUSERS.NET file, which lives on a network share.[0] I can change the file location for the entire computer, too, but what I *can't* do is set it on a database-by-database basis. This leads to much annoyingness as I try to access several different databases, each with its files in different places. Why couldn't Borland have just put all of the files in the database's working directory? ARRRRGH! [0] Oh, and I have to set LOCAL SHARE to TRUE. The default setting of FALSE doesn't allow network-shared tables and can result in database corruption even on a standalone computer. I discovered both of these facts the hard way. It's the default because occasionally it results in faster database access. <kick> -- ...computer contrarian of the first order... / http://aperiodic.net/phil/ PGP: 026A27F2 print: D200 5BDB FC4B B24A 9248 9F7A 4322 2D22 026A 27F2 --- -- I never watch Sesame Street. I know most of that stuff. -- Tracie, college sophomore. ---- --- --
Generated at 14:02 on 01 Jul 2004 by mariachi 0.52