Hi Ranchers, I have to connect to a ms access db from a jsp on tomcat(for free without paying for a driver) and after a bit of reading here is where I am at. After realising that drivers were not for free I discovered that JSK (JDKs) has a free JDBC DBC brige driver bundled with it. Problem is I cant find it and don't know what to do with it when I do. There seems to be a few tutoirals on how to use the JDBC API but not how to set up this free driver. Can anyone point me in the direction of a good tutorial/instructions. Any help would be great Williey
The Java Tutorial: JDBC Basics covers everything except creating the ODBC DSN. That depends on your version of Windows. Find your "Data Sources (ODBC)" tool under the Control Panel or Administrative Tools. Click on "Add", choose "Microsoft Access Driver", give it a name (remember the name, you need it to connect with the bridge), and select a database. That should get you started.
Hi, Well I have the the .mdb file in the same directory, still it's giving the error . My database string is: . Also, If my Main class (who is starting the app is in the different dir and from that I am creating an object that intern connect to access, do I need to give ANY path relative to that MAIN class? Or that will work...
Everyone is a villain in someone else's story. Especially this devious tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth