O7: Loosing connection to the datafile (ODB)

[brian at revolution911.com]

Jim,  I don't remember which OS you have running on the server...as I understand.... You are odbc from an application on the server to a database on the same server?  Whenever this lock issue is occurring,  there should be an event log that should give you an idea 

> On Feb 23, 2016, at 13:22, Jim Creak <jim at jacsoft.co.nz> wrote:
> 
> Thanks for the suggestions …
> 
> Virus checker is off (Not preferred, but part of limiting what could be the problem)
> 
> No Backup routines setup .. But I’ll check for one any way
> 
> Thanks
> Jim
> 
> JACSoft Programming Ltd. <http://www.jacsoft.co.nz/main.shtml>
>> On 24/02/2016, at 9:24 am, brian at revolution911.com wrote:
>> 
>> Or,   Is there a backup drive that backs up every so often that may be causing the server to disconnect .
>> 
>>> On Feb 23, 2016, at 11:56, Scotte Meredith <spomacguy at gmail.com> wrote:
>>> 
>>> Just an off the wall thought. Is there virus software running on the machine that is locking up the data file while checking it that may be causing the drop of the connection?
>>> 
>>> 
>>>> On Feb 23, 2016, at 11:39 AM, Jim Creak <jim at jacsoft.co.nz> wrote:
>>>> 
>>>> I’ve had mixed success, I don’t think it is other users violently disconnecting, this is proven by the fact that I still get lockups when no other users are logged on.  
>>>> 
>>>> I wonder if it is because I am linked on the local computer, I’ve been using odb://127.0.0.1:5913:DataName I’ll see if changing the IP number helps.
>>>> 
>>>> I’ve found a number of background processes that might cause locking issues, but I don’t know how I can prove if they are the ones playing with the datafile … Does anyone know a tool that can track which files are being accessed by different processes?  It would be nice to track what is actually playing with the datafile, I would only hope that it is the ODB.
>>>> 
>>>> Any other hints people can suggest?
>>>> 
>>>> Thanks
>>>> Jim
>>>> 
>>>> JACSoft Programming Ltd. <http://www.jacsoft.co.nz/main.shtml>
>>>>> On 17/02/2016, at 11:04 am, brian at revolution911.com wrote:
>>>>> 
>>>>> It's more likely that a connected machine is having a violent disconnect from the server machine and is locking the record on the server.   Then the local app on the server is not able to access the locked record.
>>>>> 
>>>>>> On Feb 16, 2016, at 13:58, Jim Creak <jim at jacsoft.co.nz> wrote:
>>>>>> 
>>>>>> That is a possibility that I had not considered … I can do some tests over the week-end to check this.
>>>>>> 
>>>>>> Thanks
>>>>>> Jim
>>>>>> 
>>>>>> 
>>>>>>> On 17/02/2016, at 10:27 am, brian at revolution911.com wrote:
>>>>>>> 
>>>>>>> I have never seen Omnis lose its link to the datafile which was located on the same machine.   Is it possible that the lock record is happening because one of the connected machines is losing its link which is affecting the application on the server machine?
>>>>>> 
>>>>>> _____________________________________________________________
>>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>>> 
>>>>> _____________________________________________________________
>>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>>> 
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at http://lists.omnis-dev.com
>>> 
>>> 
>>> Scotte Meredith
>>> SpoMacGuy at gmail.com
>>> 
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at http://lists.omnis-dev.com
>> 
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com