Just to close out this thread, it's now fixed. I found a native Java dBase (.dbf) file driver, and it works great in both 32- and 64-bit environments, without having to mess with ODBC or the screwy Microsoft database file drivers.

D


On 12/16/2011 10:09 PM, David Kerber wrote:
On 12/16/2011 5:54 PM, Christopher Schultz wrote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

David,

Thanks for posting back.

On 12/16/11 2:50 PM, David kerber wrote:
Figured out the cause, though I don't have it fixed yet:  I'm
running under a 64-bit JRE, and there is no 64-bit dBAse driver
installed, just 32-bit.  So I have to either find a 64-bit dbase
ODBC driver (Hah!), or switch to a 32-bit TC and JRE.
Unless you need a huge heap, running a 32-bit process might be a
better idea, anyway. You can probably improve performance a bit, too.

Another good idea is probably to "upgrade" from Access (or are you
really using dBase?) to Microsoft SQL Server (or any actual RDBMS for
that matter). :)
Yes, using real .dbf files. They're much more reliable than Access .mdbs are, IME. We're actually using them in parallel with a real SQL backend, for different purposes. It's kind of an awkward architecture the way it's being used in this particular case, but it worked great when it was first implemented, and still does for 98% of our needs. This is the first time we've had to mix the two.

The real answer, as I did a bit more digging, is to switch to a java native dbase driver, rather than going through MS's ODBC kludge. Since my app is fairly well modularized, that shouldn't be too tough (famous last words!!!!)



To answer various other issues and possibilities that had been
mentioned:  I verfied that the driver works fine on my dev machine
with UNC names, and I changed the user under which the TC is
running to the domain administrator, and that didn't help.
I believe Sun's Java started supporting UNC path names somewhere
around the late 1.5 or initial 1.6 releases, so it might not have
anything to do with the driver itself.
Ok, thanks for that tidbit; I didn't realize they came to the UNC table that late in the game.

D


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org






---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org

Reply via email to