Results 1 to 4 of 4

Thread: Java and DB's

  1. Dec 2nd, 2003, 01:18 AM #1
    delta770
    delta770 is offline

    Thread Starter
    Addicted Member
    Join Date
    Apr 2001
    Location
    Ottawa, Canada
    Posts
    181

    Java and DB's

    hi

    i'm quite good at java, and really like the language...i'm wondering how i'd get some databse connectivity going??

    i've used VB and access a lot, i'm wondering if i can do the same database stuff i can with VB

    or what db can i connect java to...easily and with mostly everything from vb and access...

    thanx
    --770
    Reply With Quote Reply With Quote
  2. Dec 2nd, 2003, 08:08 AM #2
    hayessj
    hayessj is offline
    Lively Member
    Join Date
    Dec 1999
    Posts
    106
    You can use JDBC, same idea as ODBC. You can connect to any database that has a JDBC driver, Access should not be a problem
    Reply With Quote Reply With Quote
  3. Dec 3rd, 2003, 11:11 AM #3
    CornedBee
    CornedBee is offline
    Kitten CornedBee's Avatar
    Join Date
    Aug 2001
    Location
    In a microchip!
    Posts
    11,594
    Actually Access IS a problem because MS doesn't provide JDBC drivers for their DBs. You can use 3rd party drivers or the JDBC-ODBC bridge and the Jet ODBC driver.
    All the buzzt
    CornedBee

    "Writing specifications is like writing a novel. Writing code is like writing poetry."
    - Anonymous, published by Raymond Chen

    Don't PM me with your problems, I scan most of the forums daily. If you do PM me, I will not answer your question.
    Reply With Quote Reply With Quote
  4. Dec 9th, 2003, 02:59 AM #4
    Dillinger4
    Dillinger4 is offline
    Dazed Member
    Join Date
    Oct 1999
    Location
    Ridgefield Park, NJ
    Posts
    3,418
    Yes CornedBee is correct. Sun says the following......

    "Most ODBC 2.0 drivers should work with the Bridge. Since there is some variation in functionality between ODBC drivers, the functionality of the bridge may be affected. The bridge works with popular PC databases, such as Microsoft Access and FoxPro."

    Im assuming by this statement that is would be better to get a specific driver rather than use the JDBC-ODBC bridge.

    Here is the main page for the JDBC Data Access API technology.
    http://java.sun.com/products/jdbc/

    Here is Suns look up page to find JDBC drivers for various Data Bases. http://servlet.java.sun.com/products/jdbc/drivers
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width