What u need to do is 1. Open ODBC
2. Use System DSN 3. Add ur database 4. Click advanced and put in username and password 5. On J2EE 6. Ur driver is "sun.jdbc.odbc.JdbcOdbcDriver" 7. Databse url "jdbc:odbc:<Datasource name from ODBC" Try it, it works perfectly. From: java-ee-j2ee-programming-with-passion@googlegroups.com [mailto:java-ee-j2ee-programming-with-pass...@googlegroups.com] On Behalf Of Nelson Rodrigo - LHQ Sent: 08 September 2009 08:00 AM To: java-ee-j2ee-programming-with-passion@googlegroups.com Subject: [java ee programming] MS Access Codes Dear Friends According to our requirement we want to connect ms access database with j2ee application instead of sql server. So please let me know how I work with ms access. If you have same code lease let me know. Nelson Rodrigo Staff Officer - Software Development LOADSTAR (PRIVATE) LIMITED Sri Lanka | Tel: +94 11 483 7914 | Fax: +94 11 224 0892 | Mobile: +94 77 311 6556 P SAVE PAPER - Please consider our environment before printing ΓΌ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en?hl=en -~----------~----~----~----~------~----~------~--~---
