Results 1 to 3 of 3
  1. #1
    sandysm is offline Member
    Join Date
    Apr 2010
    Posts
    4
    Rep Power
    0

    Default How to add DB connection using jdbc-odbc bridge driver

    in server explorer, i added new connection, entered my URL as jdbc:odbc:AirlineDB and as i'dont hav username, pass to my db so i left two field blank,

    the connection is not established completely giving error dialog as:

    Unable to obtain schema

    can anyone help me..

  2. #2
    Prajin's Avatar
    Prajin is offline Senior Member
    Join Date
    Jun 2010
    Location
    Ktm, Nepal
    Posts
    120
    Rep Power
    0

    Default

    does the db have user name and password? If it have you will need it.
    Include data table name also.
    More info at : -
    Establishing a Connection (The Java™ Tutorials > JDBC(TM) Database Access > JDBC Basics)

  3. #3
    arun9683 is offline Member
    Join Date
    Jun 2010
    Location
    Bangalore,India
    Posts
    70
    Rep Power
    0

    Default

    Give the database name and try ..

    Ex:
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/myDBName", username, password);

Similar Threads

  1. Help me this error in JDBC-ODBC connection
    By lordelf in forum Java Servlet
    Replies: 3
    Last Post: 04-04-2009, 08:37 AM
  2. Replies: 1
    Last Post: 10-16-2008, 02:09 PM
  3. Using JDBC-ODBC bridge
    By Java Tip in forum Java Tip
    Replies: 0
    Last Post: 02-06-2008, 09:21 AM
  4. Replies: 1
    Last Post: 08-06-2007, 09:24 PM
  5. JDBC driver connection problem
    By creativehacker in forum JDBC
    Replies: 3
    Last Post: 07-10-2007, 09:58 PM

Posting Permissions

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