> -----Original Message----- > From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Sent: Friday, April 15, 2011 1:02 PM > To: Tomcat Users List > Subject: Re: Working of Tomcat with MS Access > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Jeff, > > On 4/15/2011 11:11 AM, Jeff Hubbs wrote: > > You do realize, I hope, that what you're proposing is akin to > sourcing > > parts for your jet engine from Fisher-Price? > > :) > > > MS Access is a desktop application that accesses files on disk. Java > > apps running on Tomcat typically access an RDBMS over a network > > connection via SQL statements and their responses. AFAIK there is > not a > > "server instantiation" of MS Access; > > While you're right, I believe that MS has an Access JDBC (or ODBC) > driver that allows you to specify the file to open as part of the JDBC > URL. It's kind of like using a CSV file as a database, though...
More to the point, there's no such thing as a 64-bit ODBC driver for Access. In short, if you use Access for a data store, your app must run in 32 bit mode using a 32-bit JVM. > > Anyway, this is possible. He's just missing some configuration of some > kind. I feel kind of fortunate that I have no past experience on which > to draw to help the OP. > > Google for "read access database in Java" perhaps? > > - -chris George Sexton MH Software, Inc. 303 438-9585 www.mhsoftware.com --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org