If you find a workaround for network phantoms, you can probably make a few pennies selling it.
Dennis Fleming <[EMAIL PROTECTED]> wrote: >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/ > -- 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/
