If you can't wait for Inprise' ADO solution to come out...consider this:
http://www.kylecordes.com - select the BDE Alternatives link.
No live without an edge.
I thought that maybe it could be the wrong BDE 5.01 too, but then I assumed
my tech would have checked that. I'm a perfectionist of course and I'll be
trying it myself. There was a BDE 5.01 released as a Delphi patch a while
before the SQL Links update came out, so it could be confusing. Using
something other than BDE is not an option.
I would like to try using a similar BDE based tool, but I don't have one.
Can you suggest any?
I have observed, and continue to investigate, the issue that BDE-16 and
BDE-32 do not always seem to work well together with respect to the
all-important locking protocols. It seems appropriate for me to
recommend, then, that one should avoid getting into any situation where
16-bit and 32-bit applications are accessing the same databases at the
same time, without carefully testing the scenario first in actual
practice at your site.
In the tests I am conducting, BDE-16 2.52 is pitted against various
BDE-32's. Both of them specify LOCAL SHARE = TRUE (although I'm toggling
this switch and I do notice a response), and most importantly, both of
them DO specify the same NET FILE DIR.
Some of the outcomes I have observed thus far are:
* A 16-bit and a 32-bit session can place conflicting locks or be
of one another's locks.
* A session can encounter a "sharing violation" or "access is denied"
result from DOS, and is sometimes badly surprised by that.
* In certain operations, file damage has been observed due to
activity (no surprises here, if the locking is not working as
If you have encountered similar behavior (or unexplained behavior) at
your practice, it would be very helpful to start a meaningful thread off
Various environments have been tested: Win95, Win98, and so on. Tests
can and have been constructed on -single- machine environments, strongly
implying that not too many outside factors are likely to be contributors
here. This ought to be a situation that can be fairly quickly stripped
down to an "easy test case," but by myself I'm encountering mixed
Ladies and gentlemen around the globe, start your internet! ;-)
Sundial Services :: Scottsdale, AZ (USA) :: (480) 946-8259
5. ms acces