IDS JDBC driver probs

Discussion in 'Java' started by Albretch, Aug 26, 2004.

  1. Albretch

    Albretch Guest

    I am trying to establish a jdbc connection to a MSAccess file-based
    DBs.

    The JdbcOdbcDriver gives me no problems, but the IDS does. I have
    read their user guide docs, their faqs and tried all possible
    permutations or parameters to no avail.

    What could be the problem here?

    Have you been successful at connecting to a MS Access DB with the IDS
    JDBC driver?

    // - - - - - - - THIS IS FINE - - - - - - -
    String aDrvr = "sun.jdbc.odbc.JdbcOdbcDriver";
    String aCxURL = "jdbc:eek:dbc:Driver={MicroSoft Access Driver
    (*.mdb)};DBQ=C:\Program Files\Microsoft
    Office\Office\Samples\Northwind.mdb";
    String aUsr = "msaccess2000_JdbcOdbc";
    String aPW = "wordpass";

    .. . .
    try{
    // __ Setting Driver
    Class.forName(aDrvr).newInstance();
    Cx = DriverManager.getConnection(aCxURL, aUsr, aPW);
    if(Cx != null){
    Cx.close(); Cx = null; IsCx = true;
    System.err.println(" Connection Succesfull!");
    }
    // __
    }catch(ClassNotFoundException KNF){ KNF.printStackTrace(); }
    catch(InstantiationException InstX){ InstX.printStackTrace(); }
    catch(IllegalAccessException IlglAX){ IlglAX.printStackTrace(); }
    catch(SQLException SQLX){ SQLX.printStackTrace(); }
    .. . .



    // - - - - - - - THIS ISN'T - - - - - - -
    String aDrvr = "ids.sql.IDSDriver";
    String aCxURL = "jdbc:ids://127.0.0.1:12/conn?dsn='DRIVER={Microsoft
    Access Driver (*.mdb)};DBQ=C:\Program Files\Microsoft
    Office\Office\Samples\Northwind.mdb'";
    String aUsr = "msaccess2000_JdbcOdbc";
    String aPW = "wordpass";

    java.sql.SQLException: java.net.ConnectException: Connection refused:
    connect
    at ids.sql.IDSSocket.onException(IDSSocket.java:212)
    at ids.sql.IDSConnection.<init>(IDSConnection.java:251)
    at ids.sql.IDSDriver.connect(IDSDriver.java:93)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    .. . .

    tried also

    "jdbc:ids://localhost:12/conn?dsn='DRIVER={Microsoft Access Driver
    (*.mdb)};DBQ=C:\Program Files\Microsoft
    Office\Office\Samples\Northwind.mdb'";

    and many other variations . . .
     
    Albretch, Aug 26, 2004
    #1
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Michel Szybist
    Replies:
    0
    Views:
    457
    Michel Szybist
    Jul 21, 2003
  2. Frank Marx
    Replies:
    1
    Views:
    3,895
    =?ISO-8859-1?Q?Mario_M=E9ndez_Villegas?=
    Aug 6, 2003
  3. Rikard Eriksen

    JDBC driver for Personal Java

    Rikard Eriksen, Jul 31, 2003, in forum: Java
    Replies:
    0
    Views:
    439
    Rikard Eriksen
    Jul 31, 2003
  4. Konrad Piersdorfer

    NetBeans and MySQL-JDBC-Driver

    Konrad Piersdorfer, Sep 1, 2003, in forum: Java
    Replies:
    0
    Views:
    912
    Konrad Piersdorfer
    Sep 1, 2003
  5. vanvee
    Replies:
    0
    Views:
    650
    vanvee
    Sep 2, 2003
  6. Betty
    Replies:
    1
    Views:
    10,232
    Juha Laiho
    May 21, 2005
  7. Bruce
    Replies:
    4
    Views:
    952
    Bjorn Abelli
    Mar 25, 2006
  8. Replies:
    2
    Views:
    924
    Beat Bolli
    Jun 21, 2005
Loading...