Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 7 of 7 total |
Data not showing (Using app that shares files from a folder) |
Fri, Jul 19 2013 1:46 PM | Permanent Link |
kamran | Hi
I have an app that runs on 3 machines 1. server = Vista 64 bit O/S where that data is stored on a shared folder eg c:\appdata 2. ws1 = Vista 64 bit O/S 3. ws2 = Windows 7 64 bit O/S From time to time I am not seeing the data from the tables eg in grids or edits. This happens to random files and at random times. The data is clearly on the server but loses itself randomly on the workstations? I have disabled the write cache on the hard drives but that does not seem to help. Is there an issue somewhere with setup / dbisam itself ? I do recall that it was running ok before .. but something has changed. I regularly move onto the latest dbisam versions and am currently on 4.34 but software on site might still be using a slightly lower version. Any ideas ? Regards Kamran |
Sun, Jul 21 2013 2:43 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kamran,
<< I have an app that runs on 3 machines 1. server = Vista 64 bit O/S where that data is stored on a shared folder eg c:\appdata 2. ws1 = Vista 64 bit O/S 3. ws2 = Windows 7 64 bit O/S From time to time I am not seeing the data from the tables eg in grids or edits. This happens to random files and at random times. >> What do you mean by you're not "seeing the data" ? Are the workstations refreshing in order to see any changes made by other users ? Unless you explicitly refresh a table/live query result, you're not necessarily going to see changes by other users immediately. http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Change_Detection Tim Young Elevate Software www.elevatesoft.com |
Mon, Jul 22 2013 5:56 AM | Permanent Link |
kamran | Hi Tim
Thanks for response. I will look into what you suggested. Funny thing is it never used to happen and seems to be a new occurrence. The system has been in for some time. Let me explain. If I fire up a client and go to the page where i have defined a grid linked to data table there would be no rows showing ? I go back to the server and the data is definitely there. So why is the data not showing up in the grid. The file is open and should show straight away as it does on the server machine ! Thanks Kamran "Tim Young [Elevate Software]" wrote: Kamran, << I have an app that runs on 3 machines 1. server = Vista 64 bit O/S where that data is stored on a shared folder eg c:\appdata 2. ws1 = Vista 64 bit O/S 3. ws2 = Windows 7 64 bit O/S From time to time I am not seeing the data from the tables eg in grids or edits. This happens to random files and at random times. >> What do you mean by you're not "seeing the data" ? Are the workstations refreshing in order to see any changes made by other users ? Unless you explicitly refresh a table/live query result, you're not necessarily going to see changes by other users immediately. http://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=Change_Detection Tim Young Elevate Software www.elevatesoft.com |
Mon, Jul 22 2013 8:44 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | kamran
Has the program been recompiled or changed in anyway recently? What you describe sounds as though the grid isn't connected to the data and Delphi has been known to remove the links. Also do you anywhere in the program disable the grid, DisableControls on the table or break the links yourself? Finally, if when the data isn't seen what happens if you open DBSys on the client and try to view the data? Roy Lambert [Team Elevate] |
Mon, Jul 22 2013 9:26 AM | Permanent Link |
kamran | Hi Roy
The data shows on the client after coming out of the application and going back in. Later on it might not show..... how odd. It gives the impression that the whole data file is empty; I have checked that data is not being disabled I will have to look into it further to isolate it; Thanks Roy Lambert wrote: kamran Has the program been recompiled or changed in anyway recently? What you describe sounds as though the grid isn't connected to the data and Delphi has been known to remove the links. Also do you anywhere in the program disable the grid, DisableControls on the table or break the links yourself? Finally, if when the data isn't seen what happens if you open DBSys on the client and try to view the data? Roy Lambert [Team Elevate] |
Mon, Jul 22 2013 10:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | kamran
From your other post I see you're thinking of going over to c/s. I never had anything like this in years of using DBISAM in f/s mode with several clients. It may have something to do with the mix and the versions. I had a couple of thoughts: 1. add a timer onto the form and if the table(s) aren't in edit mode refresh every 5 seconds. 2. If there's space on the form display the table(s) RecordCount - that would at least give a clue as to wether the table just wasn't being displayed or was disappearing into the ether. Has there been any corruption in the table(s). I'm wondering if there's a weird problem with the network. Roy Lambert [Team Elevate] |
Tue, Jul 23 2013 9:32 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Kamran,
<< If I fire up a client and go to the page where i have defined a grid linked to data table there would be no rows showing ? >> And the rows were added prior to the application being launched, or just prior to the form with the grid being shown ? If it is the first situation, then you could very well be looking at an SMB2 bug, in which case the only solution is to a) apply a hotfix from MS, b) modify the registry on each client, or c) move to using DBISAM C/S with the DBISAM Database Server. Thanks, Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |