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

whats needed for JDBC:ODBC??

Options
  • 12-11-2005 12:29am
    #1
    [Deleted User]
    Posts: 0 ✭


    hi i am just wondering what exactly is needed for JDBC:ODBC communication??

    i have odbcad32.exe installed on my machine. where can i install the jdbc bridge or driver from????


Comments

  • Options
    #2
    Karoma
    Registered Users Posts: 19,396 ✭✭✭✭Karoma


    v?J2EE? or SE?
    I had a quick glance at this,it looks like it could be helpful for a start:
    http://www.informit.com/guides/content.asp?g=java&seqNum=37&rl=1

    Drivers:
    http://developers.sun.com/product/jdbc/drivers


  • Options
    #3
    madramor
    Closed Accounts Posts: 324 ✭✭madramor


    Deleted User wrote:
    hi i am just wondering what exactly is needed for JDBC:ODBC communication??

    i have odbcad32.exe installed on my machine. where can i install the jdbc bridge or driver from????

    1:
    heres a tutorial
    http://java.sun.com/developer/onlineTraining/Database/JDBCShortCourse/jdbc/jdbc.html
    note jdbc-odbc is not recommended for production code.

    2:
    All you need is the odbc tool that you have above and a jdk

    3:
    the bridge driver sun.jdbc.odbc.JdbcOdbcDriver is part of the jdk

    4:
    you install the driver at run time in your code

    5:
    there no configuration for jdbc-odbc outside of your java code,
    apart from setting up the data source in the ODBC Data Source Admin


  • Options
    #4
    [Deleted User]
    Posts: 0 ✭ [Deleted User]


    thanks guys

    to karoma. im using j2sdk1.4.0 which is the standard edition one can only assume.


  • Options
    #5
    Karoma
    Registered Users Posts: 19,396 ✭✭✭✭Karoma


    Deleted User wrote:
    thanks guys

    to karoma. im using j2sdk1.4.0 which is the standard edition one can only assume.
    It's part of the API,so.
    Good luck.


  • Options
    #6
    [Deleted User]
    Posts: 0 ✭ [Deleted User]


    the reason i asked is i keep getting an sql exception and taught it may have been something to do with my JDBC:ODBC driver.


  • Advertisement
  • Options
    #7
    pH
    Registered Users Posts: 4,188 ✭✭✭pH


    The JDBC-ODBC bridge is a bit of a no-no. why are you using it? , can you not get real jdbc drivers for whatever database you're trying to communicate with?


  • Options
    #8
    [Deleted User]
    Posts: 0 ✭ [Deleted User]


    pH wrote:
    The JDBC-ODBC bridge is a bit of a no-no. why are you using it? , can you not get real jdbc drivers for whatever database you're trying to communicate with?

    i am a student of IT and want to set this up on my own home computer. i am trying to insert values into a MS access DB


Advertisement