Thanks for that, Jackie. I always appreciate your insights. For those interested, the product is from Netdirect, at j-netdirect.com. In fact, there is a nice FAQ they put together that answers the question, "What is the difference between JDataConnect and the JDBC-ODBC bridge?":
http://www.j-netdirect.com/JDataFAQ.htm#Tech002 Indeed, the FAQ is a decent one that answers a lot of questions one may have. Also, see their "product info" pages as they're more informative than many. The company seems to recognize that developers have lots of questions they want answered. I appreciate that. The price for a single machine is 499, but I notice that they offer a trial for 30 days and after that it reverts to an unlimited "standard" license which simply limits the tool to only one concurrent connection. That's decent of them, as well, to allow adequate testing. /charlie -----Original Message----- From: Jackie Comeau [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 12:46 PM To: JRun-Talk Subject: RE: access a MS Access DB from Jrun JDataConnect is a good jdbc driver for Access. On Tuesday, November 20, 2001 11:35 AM, charles arehart [SMTP:[EMAIL PROTECTED]] wrote: > 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
