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: Prichard-Levy Austin <[EMAIL PROTECTED]> > date: Wed, 11 Sep 2002 12:56:22 > to: [EMAIL PROTECTED] > subject: Re: Ms Access and Java Servlets-Applet > > Any odbc datasource can be accessed from jdbc using the odbc bridge, providing the >odbc drivers exist for the datasource type. Specifically, if the connection/query is >handled via a web app servlet, only the web server hosting the servlet needs to have >the relevant odbc driver installed (i.e. NOT the web client). > > I did something similar recently, by retrieving data from Excel spreadsheets (you >can also update an xls in the same manner, but that's another tale) and pushing it >into Sybase while displaying the data back to the user's web page. just treat the >Access db in your jdbc connection and query code as you would any other db and the >rest should be straightforward. > > It ain't rocket science or StarTrek and odbc's still a piece of junk compared to >true native db drivers, but it does provide a solution to the sub-Enterprise >datasources that still inhabit Bill's World... > > Hope this helps. > > Austin > > > from: "RUTHERFURD, Michael" <[EMAIL PROTECTED]> > > date: Wed, 11 Sep 2002 01:51:27 > > to: [EMAIL PROTECTED] > > subject: Re: Ms Access and Java Servlets-Applet > > > > > 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). > > > > Michael Rutherfurd > > > > ___________________________________________________________________________ > > 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 > > > > > > from: "RUTHERFURD, Michael" <[EMAIL PROTECTED]> > > date: Wed, 11 Sep 2002 01:51:27 > > to: [EMAIL PROTECTED] > > subject: Re: Ms Access and Java Servlets-Applet > > > > > 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). > > > > Michael Rutherfurd > > > > ___________________________________________________________________________ > > 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
