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...
----<br />Nirav Patel<br />Software is the bottleneck in the digital world!
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com