Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Using OpenOffice database in java app

Options
  • 18-11-2005 2:00pm
    #1
    VanStrummer
    Closed Accounts Posts: 32 ✭


    I'm trying to just create a simple login program using java and a .odb

    I'm not really sure about how to use the JDBC and its really starting to kill me.
    What drivers do i need to use it or can it be done?

    Any help would be great??

    thnx


Comments

  • Options
    #2
    clearz
    Registered Users Posts: 885 ✭✭✭clearz


    1) Go to Control panel in Windows. Open up 32-bit
    ODBC administrator. On some computers, you have
    to open up Administrative Tools to get to "Data
    Sources - ODBC"
    2) Click on "System DSN"
    3) Click on "Add"
    4) Select "Microsoft Access Driver(*.mdb) and click Finish.
    This will open up the "Microsoft ODBC Access Setup" window.
    5) Give a name to your ODB data.
    6) Click the "Select..." button to open up the Select Database window.
    7) In the pull down on the lower left (List Files of Type), select
    the second option, which should be "All Files (*.*)"
    8) Browse for your ODB data file and then click OK, then
    keep clicking Ok.


    Then connect to the ODBC source using the standard Java method (I hope you dont need this told to you.) There is tons of stuff on google about it anway.


  • Options
    #3
    VanStrummer
    Closed Accounts Posts: 32 ✭VanStrummer


    cheers, hopefully this sets me on my way.

    thanks again.


Advertisement