We have this problem periodically. What we are seeing is premature aborts from R:Base, or Windows screens of death, not being logged off the files on the server. The phantom sessions need to be closed on the server to free the file locks.
We have not yet found any way to automate this. Bernie Corrigan <[EMAIL PROTECTED]> 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/ > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.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/
