You are right in saying it's the driver. It doesn't support many features, has multiple connection issues, is slow, etc. In most cases, I wouldn't even using it just for testing or proof of production. When I started using it a while back, i had problems that were unsolvable, that magically were fixed when i used a new driver.
As for access, we've used access in cold fusion apps before too, but quickly stopped that after data started going missing. And this wasn't even a heavy hit server, it was an internal app for a company that completely relied on the database, maybe 10 users tops. The minute a database starts losing data, is the minute you get rid of it and never use it again. We moved the exact same app with the exact same db structure to MS SQL Server and voila, problem fixed. That is just one reason why you should not use access for anything that is important. That doesn't even take into account that it's slow, etc... And why use a database that is... well junk, that you have to pay for when you can use a reliable database like mySQL for free? Travis ---- Original Message ---- From: charles arehart <[EMAIL PROTECTED]> Sent: 2001-11-20 10:26:35.0 To: JRun-Talk <[EMAIL PROTECTED]> Subject: RE: access a MS Access DB from Jrun Right, we're in agreement. I too have apps built years ago with ColdFusion and Access that still run with no problem having hundreds if not thousands of hits per day, but there will be others who'll want to jump in and declare Access null and void "for production" right off the bat. I was just hoping to temper that oft-raised debate. They may very well still wade in responding to Tamas' original note before reading ours. :-) But I'm intrigued by your assertion that "the problems with the JDBC-ODBC Bridge driver far outweighs Access's limitations". Are you saying that you found that you couldn't even do the equivalent application in Java using the JDBC-ODBC driver? Or in other words, that all things being equal (regarding volume and nature of access to the database) an app using the JDBC driver would not perform as well as it might because of the driver itself? (Of course, I'm again not trying to open the debate of ASP or CF vs JSP/servlets: I'm referring just to any anecdotal experience to suggest that the JDBC-ODBC driver itself would be specifically at fault for poorer performance than an equivalent app written in another platform accessing the same Access DB.) If that's the case, then it would seem the conclusion would be to use Access only for proofs of concept, extremely light load apps, etc, and move to another DBMS, as you did, for production. I suppose that was the meaning in the Sun's recommendation to not use it for "production". It's just that blanch at such overarching statements because "production" means so many things to so many people. Indeed, the same argument is made against Access, but as we've discussed that's not always a fair accusation. But it sounds like the argument against the driver isn't the same as the argument against Access. Thanks for clarifying that. I wonder, given that some would still want to try to use Access in the right circumstances, if anyone or any company has come out with an alternative JDBC driver for Access? /charlie -----Original Message----- From: Fishwick, Randall [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 11:57 AM To: JRun-Talk Subject: RE: access a MS Access DB from Jrun 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
