ODBC on Linux?
I have a servlet now working on an Windows platform using the ODBC-JDBC driver to connect to MSAccess databse. My web hosting provider is on Linux. Any suggestions on how this should work or can one even use a *.mdb file on Linux seeing there is no ODBC connection possible?
What databases can I use and what driver with Java? Please keep in mind I cannot pay for anything too expensive as this is for educational purposes..
Any example code would be great in addition with the driver names, etc...
Thx in advance,
-C (cweubanks@mindspring.com)
MS ACCESS is a file based junk and used for very limited purposes....Oracle offers a lot of free downloads....Personal edition oracle for windows is downloadable free from the internet and will work at least a 100 times better than access on windows...JDBC drivers can be downloaded from the oracle's web site itself//
Well......deviating a little from your question....
If you really want excellent performance for no money...then get rid of windows and install linux as the OS...Almost all linux distributions are available free on the internet with tons of built-in applications.... check out www.linux.org, www.redhat.com for starters....
Oracle offers Enterprise edition database as free downloads for linux platforms...And there are tons of other office products and productivity software available free for the linux platform....Linux can even run on your old 386 processor if you have one and still give you a good performance...... More reasons to consider linux....
Well....one warning here...linux has a steep learning curve to start with but once you cross that, there is nothing like linux....
-Prowzen-
Oracle might be a choice, but take a look at mysql as well (http://www.mysql.com). It is fairly small and easy to install. Has excellent performance and there is a JDBC type 4 driver for it. You can find all of it on the site.
And oh, it is free for depending on your situation. If you already have an application which uses JDBC I don't think you need example code. It should be fairly easy to make the change, probably only some access-specific SQL statements need to be re-written, as dialects may differ.
esmo at 2007-6-29 0:57:01 >
