Bernie/Albert, Thanks for picking up this thead.
I do make sure that Set Multi has been succesfully set off before Reloading the data base. So, once the Reload finishes successfully, Disconnect should find only one RBase users logged in. But... I have had a problem where no one was in the application, and yet the data base files where still open. They restarted the server in order to close the data base files, which does not sound like a good solution. So, back to my problem. If you are in single user mode (SET MULTI OFF) and you are unable to Disconnect, then a table could be left open with Locks On? I.e., would RBase allow a successful Disconnect if any table has Locks On? But, this still doesn't make sense because if my Disc/Conn was successful with Multi Off, then no one can Conn and/or Lock tables until the data base is Reloaded and Multi is Set On again. I guess Albert makes the key point. Rbase sees only one user and Multi is Off, but when I Disconnect and attempt to Delete/Rename files, then NT "sees" a phantom user still using the data base files. Workaround??? TIA, Dennis ***** At 12:13 AM 12/5/02 -0800, you wrote: >I'm reposting this as it never arrived back out here in Oregon. This is the >second time in a week that one of my postings to this list went down the >black email hole. > > >AFAIK that won't work if you are staying connected in multiuser mode. You >have to do the following: > >DISCONNECT >SET MULTI OFF >CONNECT dbname >RELOAD new_dbname >DISCONNECT >DELETE dbname.rb? >REN new_dbname.rb? dbname.rb? > >It sounds like you are staying connected in multiuser mode. If you are >connected with MULTI set to OFF and still having this problem then it is >probably a situation where locks placed by SHARE, or its equivalent in your >system, are not getting released so that the file cannot be deleted. > >--------------------------------------- >At 05:46 PM 12/4/2002 -0500, you wrote: >>RBase 6.5++ >> >>We've had a couple of post on this one and I am still trying to nail it down. >> >>In my Reload code I make sure that only one user is using our multi user >>app by attempting to Set Multi Off, and then if Reload has no errors: >> >>Disconnect >>Delete old_dbname.rb? >>Rename new_dbname.rb? old_dbname.rb? >>Connect old_dbname >>.... >> >>And, I get: >> >>-ERROR- Cannot delete connected database. (2078) >>Failed renaming .... Etc. >> >>If the user doing the Reload is the only user, then why doesn't Disconnect >>work? I can check there is no error on the Disconnect command. (I'm >>assuming the next command won't be executed until all modifications are >>writing to disk and the data base is closed, but that may not be the case.) >>Any help appreciated, >> >>Dennis >>***** >> >> >>Dennis Fleming >>IISCO >>http://www.TheBestCMMS.com >>Phone: 570 775-7593 >>Fax: 570 775-9797 >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > > Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Fax: 570 775-9797 ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
