typo "packet" not "packed"
----- Original Message -----
From: "Mike Byerley" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, August 19, 2010 4:11 PM
Subject: [RBASE-L] - RE: Corrupt DB
That's just silly. Garbage in garbage out.
DB engines don't have packed inspection.
When the data stream gets to the engine, it is no longer a packet.
It has been assembled into coherent data at the workstation by the
Nic/network software layer.
----- Original Message -----
From: "MDRD" <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Thursday, August 19, 2010 3:31 PM
Subject: [RBASE-L] - RE: Corrupt DB
Paul, Mike, Karen, Bill, Emmit ......All
But could he say Access is a light weight and other more robust DB engines
(SQL server) should be able to handle bad packets?
Remember he use to be a MS tech where they charges $500 an hour to send
him out to companies, at least that's how the story goes.
Also I can not find much info on corruption that other DB, and the program
that is trying to replace my App is SQL Exp.
I thought I read somewhere all client server DB's are less prone to
network issues compared to file server DB's?
Thanks... please keep the info coming, I plan on sending him all of this
and I will CC my user too
Marc
From: Paul InterlockInfo
Sent: Thursday, August 19, 2010 12:37 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Corrupt DB
simple with Google and funny to see the list. Number One ! NETWORK
CARDS (that includes wiring, switches, hubs <gig>, etc.. ) HARD DRIVES
Google: db AND packets AND corruption
Results:
1. Access/VBA Tutorials - Access Database Corruption Repair Guide
Network cards that lose packets and hard drives that have bad sectors are
highly likely to cause database corruption (as well as many other computer
...
www.everythingaccess.com/tutorials.asp?...Database-Corruption... -
Cached - Similar
2. 65518: Samba smbd process.c chain_reply Function SMB1 Packet ...
Jun 18, 2010 ... Download DB. 65518 : Samba smbd process.c chain_reply
Function SMB1 Packet Chaining Memory Corruption Printer |
http://osvdb.org/65518 ...
osvdb.org/show/osvdb/65518 - Cached
3. 5 Simple Tips To Prevent MS Access Database Corruption
Remember that the corruption flag can be set from the slightest packet
loss between your computer and the database file. MS Access has sometimes
been called ...
ezinearticles.com/?5-Simple-Tips...Database-Corruption... - Cached -
Similar
4. Get IT Done: Top 10 ways to prevent Access database corruption
Apr 2, 2002 ... Get IT Done: Top 10 ways to prevent Access database
corruption ... collisions occur and so fewer packets have to be present
across the wire. ...
articles.techrepublic.com.com/5100-10878_11-1060083.html - Cached -
Similar
5. Microsoft Access Database Corruption Issues
Network cards can lose packets and hard drives can experience bad sectors
which are contributing factors not only to database corruption but to
other ...
www.access-programmers.com/Scalability/CorruptionIssues.aspx - Cached
Notice all but 3 is Access, and the list goes on.
Give me a break, he has a hole in the bucket dear Johnny!
Sorry for the rudeness and cut/paste but .. Perhaps you could send him
a link? ? to Google? or Yahoo.
Sincerely,
Paul D
**
Well on the bright side, thank you Google. If any rights/tm/patents were
violated it was not the intention of this response and I apologize in
advance.
From: [email protected] [mailto:[email protected]] On Behalf Of MDRD
Sent: Thursday, August 19, 2010 1:06 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Corrupt DB
Hi
I have this one user that keeps getting corruption in this one table. For
the most part this is the only office having a problem.
They have a computer tech that is some hot shot MS certified network
something or other and I am over my head in discussing
what may be causing the problem. As luck would have it this office has a
lot of influence with my other users so I really need
to nail this down.
They were able to add 1,100 rows of data since the last corruption, so I
told the tech that I do not think it is RBase or my app
also they are basically the only office having a problem. I suggested
some kind of junk data in one of the rows and everytime
they hit that row of data or that customer it corrupts the DB but I am
only grabbing at straws.
He sent me this... so how should I respond? I can find tons of links
about Access corruption due to network issues, but is he talking about
a CS db compared to file server db?
From a network standpoint, it cannot corrupt the database. The packets
could get corrupted, but then you'd have to ask why the program you use as
the engine for PS (this my app), then commits a corrupt packet of
data...their engine is the only thing that can modify the file. That is
what I'm getting at here...only they and the local hardware/3rd party
software can modify that dbase on the local machine. Or do they allow that
other workstation to make direct edits over the network? That would be
crazy...
Again, yes, the local hardware and third party software can indeed cause
corruption to the physical file, but I would highly doubt it would happen
at the same place/table of a Db each and every time. That is one if the
things that says software/process about this.
Can you tell me how their flow goes? How they edit from a client etc? I
need to understand how the Db engine works. That will help whether it's
software or hardware...it will tell us where and when to look.
thanks for any help
Marc
