Sorry, I forgot to mention that you might need to use the MS odbc-jdbc bridge DLL rather than Sun's, and avoid using complex or exotic queries as the odbc implementations for non-industrial strength datasources tend to support rather primitive compliance with the odbc specification(s). And, yes, none of this would be recommended for a production system, but if its the only way forward, you've got little to lose by trying it out.
Having read all the caveats, it has to be said on the credit side that odbc has improved greatly over the years stability-wise so you may well have few problems, its just that its throughput performance isn't brilliant because of the compromises it has to make in order to remain an "open" standard. Austin > from: Steve Glasser <[EMAIL PROTECTED]> > date: Wed, 11 Sep 2002 12:57:39 > to: [EMAIL PROTECTED] > subject: Re: Ms Access and Java Servlets-Applet > > You can use ANSI-92 SQL with MS Access without a problem. Access like other > databases (ie. Oracle, mySQL) has proprietary features that are not part of > the ANSI specification. Just stay away from those and you will be fine. > > I would agree that Access and ODBC-JDBC is not a preferred configuration for > production, but I have a client that we have used Access on a moderately > busy web site for a three years now without a problem. I would prefer > something else, but it's tough to convince them when it works. > > Steve > > -----Original Message----- > From: Galbreath, Mark [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 11, 2002 6:46 AM > To: [EMAIL PROTECTED] > Subject: Re: Ms Access and Java Servlets-Applet > > > And Access uses a proprietary (imagine that) form of SQL that is supported > only by Microsoft ODBC-JDBC drivers (imagine that). And Milt is correct, > the bridge drivers are not recommended for production use. > > Mark > > -----Original Message----- > From: Milt Epstein [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 10, 2002 9:02 PM > To: [EMAIL PROTECTED] > Subject: Re: Ms Access and Java Servlets-Applet > > > On Wed, 11 Sep 2002, RUTHERFURD, Michael wrote: > > > > I'm not an MS person, but pretty much all I've heard about using > > > Access with servlets can be summed up in one word: Don't. (Yes, a > > > contraction counts as one word! :-) > > > > > > Milt Epstein > > > > Milt, were any reasons given (technical, not evil empire)? I'm > > interested as I'm currently having to simulate the prod DB in ms > > access (the prod db will be a funky teradata box but they haven't > > got the hardware yet). > > Yes, the reasons were technical (e.g. things didn't work well, both > because of Access and the JDBC-ODBC bridge -- which I believe isn't > recommended for production use). I don't really recall details, but > that's what the archives are there for, no? > > Milt Epstein > Research Programmer > Integration and Software Engineering (ISE) > Campus Information Technologies and Educational Services (CITES) > University of Illinois at Urbana-Champaign (UIUC) > [EMAIL PROTECTED] > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html > > ___________________________________________________________________________ > To unsubscribe, send email to [EMAIL PROTECTED] and include in the body > of the message "signoff SERVLET-INTEREST". > > Archives: http://archives.java.sun.com/archives/servlet-interest.html > Resources: http://java.sun.com/products/servlet/external-resources.html > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html ___________________________________________________________________________ To unsubscribe, send email to [EMAIL PROTECTED] and include in the body of the message "signoff SERVLET-INTEREST". Archives: http://archives.java.sun.com/archives/servlet-interest.html Resources: http://java.sun.com/products/servlet/external-resources.html LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
