DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/index.php)
-   Java (http://www.daniweb.com/forums/forum9.html)
-   -   Writing to an Access Database using Java... (http://www.daniweb.com/forums/thread458.html)

Fyrelion May 19th, 2003 12:36 pm
Writing to an Access Database using Java...
 
Hi,

I was wondering how you write to an Access Database using current Java versions. I've been looking pretty hard for awhile with a teacher and some friends, but so far we haven't come up with anything. Could you guys help me out?
Thx


Quote:

Never eat soggy waffles. They Nasty!

lohengrin332 Jul 16th, 2003 2:49 am
Re: Writing to an Access Database using Java...
 
For most database systems, you can simply download a JDBC driver to connect to the Db with Java, but there aren't any free ones for Access. What I ended up having to do was create an ODBC datasource (with Windows), and use the JDBC-ODBC bridge to connect to that. I think the JDBC-ODBC bridge is included with the JDK package. Good luck!


David

Mayaka Jul 28th, 2003 10:55 am
Re: Writing to an Access Database using Java...
 
Hi,
You can create an access datasource in Win2k as follows: Start->Control panel->Administrative tools->Data Sources(ODBC)->MS Access Database->System DSN->Add->Select MS Access Database Driver ->Finish->Enter datasource name->Select Database->Click ok
Mike.

NB:For more details, contact mikemayaka@yahoo.co.uk


All times are GMT -4. The time now is 1:13 pm.

Forum system based on vBulletin Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
©2003 - 2009 DaniWeb® LLC