This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
I've got MS Access and haven't been able to figure out how to set up a JDBC/ODBC bridge to connect to it. Is there something other than the JDKSE that I need to down load? What driver and connection code do I need to run?
I have this little program that I use when I want a quick "how to" jdbc lookup. This is the entire program that connects to an access database. The only thing you need to do is to install the jdk(1.3 is what I'm using) and the jvm. Here it is:
where "C:\\Temp\\data\\emp.mdb" is the path to the mdb(emp.mdb in this case) plus escape characters for the \ characters and "username"&"password" are the username and passwords that I set up in Access for security. and no, you don't have to set up a DSN and all that hassle, this is a DSNless connection to access Jamie