Charlie, Agreed in principle. But our company used an Access database with ODBC and Active Server Pages for several years with no serious problems. This was a web based telephone number lookup that was accessed hundreds if not thousands of times a day. The point being that the problems with the JDBC-ODBC Bridge driver far outweighs Access's limitations. We're now using both Oracle and SQL Server for our JSP/Servlet based web applications.
.Randy -----Original Message----- From: charles arehart [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:35 AM To: JRun-Talk Subject: RE: access a MS Access DB from Jrun Of course, keep in mind too that Access itself is "not very good for heavy duty projects". For small volume apps, or in the very early stages of an app, it can suffice, but there are indeed many benefits of moving to a better DBMS platform. I don't think we need to open any can of worms about this. Sometimes people want to demonstrate a proof of concept with something as simple as Access. Beyond that, they really should consider something more substantial, if anything more than a few people will hit the DB at any one time. Of course, that can still translate to hundreds of users per day. Just be careful. /charlie -----Original Message----- From: Mark Phelps [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 10:40 AM To: JRun-Talk Subject: RE: access a MS Access DB from Jrun You just need to obtain a JDBC driver for Access. Sun provides a driver called the JDBC-ODBC bridge which would work. You can download it from www.javasoft.com. I have heard from others on this list, however, that this driver is not very good for heavy duty projects. Perhaps somebody on the list knows of a better driver out there somewhere. -----Original Message----- From: Tamas Vertse [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 8:24 AM To: JRun-Talk Subject: access a MS Access DB from Jrun Hey, I have a Jrun server 3.0 and I would like to access an mdb file from a JSP file under Jrun. How can I do it? (My Jrun is standalone. I haven't linked any external webserver to it.) I wait your respones. Thanks, Tamas ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
