AFAIK no one does claim that MS-Access should be used as a backend datastore for an enterprise web app, not even Microsoft advocates. Microsoft provide SQL Server for this. I personally use MySQL.
Regards Jim. > -----Original Message----- > From: Stone, Timothy [mailto:tstone@;cityofhbg.com] > Sent: 12 November 2002 19:48 > To: Tomcat Users List > Subject: RE: Tomcat -> Access Connection. > > > Craig makes a valid point. > > I should further qualify my answer however and say I was only > "seconding" the original reply noting > sun.jdbc.odbc.JdbcOdbcDriver may be the only option for > MS-Access. (I can't think of any others off the top of my > head and had to see what the books were saying on the topic.) > > /DB Programming the JDBC and Java/ points some of Craig's > notes out in detail, which I should have noted. I just felt > the answering question on the choice of a backend data store > was a bit off topic for the list. I do agree that MS-Access > has very little place in enterprise web applications (let our > Micros~1 advocates vehemently protest that statement). Both > sun.jdbc.odbc.JdbcOdbcDriver and MS-Access are poor choices > in any environment other than a learning/tutorial/academic one. > > Tim > > > > -----Original Message----- > > From: Craig R. McClanahan [mailto:craigmcc@;apache.org] > > Sent: Tuesday, November 12, 2002 14:32 > > To: Tomcat Users List > > Subject: RE: Tomcat -> Access Connection. > > > > > > > > > > On Tue, 12 Nov 2002, Stone, Timothy wrote: > > > > > Date: Tue, 12 Nov 2002 13:25:03 -0500 > > > From: "Stone, Timothy" <[EMAIL PROTECTED]> > > > Reply-To: Tomcat Users List <[EMAIL PROTECTED]> > > > To: Tomcat Users List <[EMAIL PROTECTED]> > > > Subject: RE: Tomcat -> Access Connection. > > > > > > Ditto. > > > > > > I believe JDBC-OBDC bridge (sun.jdbc.odbc.JdbcOdbcDriver) is the > > > MS-Access option (I have two O'Reilly books here that > > present this class > > > as the MS-Access option). > > > > > > > The JDBC-ODBC driver can be used to connect to MS Access > > databases, but > > it's not a recommended solution for servlet/JSP based > > applications -- it > > does not deal well with multiple simultaneous requests, which > > is pretty > > typical in a multiuser web app. You're likely to have no > end of wierd > > problems due to this. > > > > For that matter, MS Access isn't really designed for this > sort of use > > either. > > > > > Tim > > > > Craig > > > > > > -- > > To unsubscribe, e-mail: > <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> PLEASE READ: The information contained in this email is confidential and intended for the named recipient(s) only. If you are not an intended recipient of this email you must not copy, distribute or take any further action in reliance on it and you should delete it and notify the sender immediately. Email is not a secure method of communication and Nomura International plc cannot accept responsibility for the accuracy or completeness of this message or any attachment(s). Please examine this email for virus infection, for which Nomura International plc accepts no responsibility. If verification of this email is sought then please request a hard copy. Unless otherwise stated any views or opinions presented are solely those of the author and do not represent those of Nomura International plc. This email is intended for informational purposes only and is not a solicitation or offer to buy or sell securities or related financial instruments. Nomura International plc is regulated by the Financial Services Authority and is a member of the London Stock Exchange. -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>