Networking ODB
Submitted by James Brown on February 28, 2008 - 11:51pm.
I had thought that ODB could be networked but I can not find any references in the docs but it does mention it on the main page of ODB as a feature. I have moved the ODB datafile and the zipcode files to a folder on our server. Everything works fine until a second user tries to access the database. We get:
Unable to open Database
Error #3050: Couldn't lock file
Can two or more users be in the database at the same time? I knew that we would not be able to have two users looking at the same record.
Am I doing something wrong?
- Login to post comments
I'd suggest going directly to the ODB folks
James,
sharing a database over a network is just complicated enough that your time is probably best spent either looking at the docs for ODB (which I'm guessing you've already done), or posting to the support forums and/or calling the ODB folks. My guess is that it's a permissions thing, but I think you'll get a better answer faster from the source.
Agreeing with Arif, plus...
I agree that going to the ODB folks is probably your best bet (and I know you've found that productive in the past.) I'd also check out the settings within ODB itself; there might be something in there about locking or not locking the database when it's being used by multiple users. Good luck!
Arif was right... again...
As it turns out, it was a permissions thing within the server and had little to do with ODB itself. The key was to make sure that everyone that needed to get to the database had full read/write permissions on both the data and zipcode files. It is working perfectly now.
Thank you Arif, thank you Jack, and special thanks to Rich Cowan over at ODB for not making the solution so easy that I would not learn anything.
James Brown
Future Drupal Guru