JDBC


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: JDBC

  1. #1
    Kiran Prabhu Guest

    JDBC

    hi
    Can anybody?

    How can i find what kind of JDBC-ODBC bridge drivers intalled on my system.
    Also where can i find these drivers.
    Oracle and access drivers could be use full for me.

    bye
    kiran



  2. #2
    Dan Adamson Guest

    Re: JDBC


    "Kiran Prabhu" <connectprabhu@hotmail.com> wrote:
    >hi
    >Can anybody?
    >
    >How can i find what kind of JDBC-ODBC bridge drivers intalled on my system.
    >Also where can i find these drivers.
    >Oracle and access drivers could be use full for me.
    >
    >bye
    >kiran
    >
    >

    The sun.jdbc.odbc.JdbcOdbcDriver was installed with your recent JDK. This
    can access Oracle. In the case of the jdbc-odbc bridge though, the problem
    is with the user's computer. Each user must have an ODBC data source defined
    on their machine which points to the database you're accessing. If you're
    using Windows NT, this is in the Control Panel (ODBC Data Sources). I have
    not been able to get the jdbc-odbc bridge to work with file-based data sources.
    I'm not sure why that is, because it should work, then you could pass the
    connection information to the user's computer at runtime. Also, there are
    drivers out there which are specific to Oracle and Access, but you don't
    want to use those, unless you depend on some special function of Oracle or
    Access which is not part of the ODBC specification. Feel free to contact
    me directly if you're having trouble, I'm a very helpful guy, and I've just
    been through this nightmare in my company...

    dna_man@yahoo.com
    dan.adamson@wallst.com


  3. #3
    Dan Adamson Guest

    Re: JDBC


    "Kiran Prabhu" <connectprabhu@hotmail.com> wrote:
    >hi
    >Can anybody?
    >
    >How can i find what kind of JDBC-ODBC bridge drivers intalled on my system.
    >Also where can i find these drivers.
    >Oracle and access drivers could be use full for me.
    >
    >bye
    >kiran
    >
    >

    You can also try this in your code, and if you get a ClassNotFoundException,
    then there's a problem.

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

    That's the code to register the jdbc-odbc bridge driver.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center