hi All :)
I am in trouble with jdbc odbc drivers
can someone please save me
here is my problem :
i am trying to connect to a simple ms acces database (db1) with easysoft's EJOP driver program
but  i am having trouble with connection 
i almost tried all possible combinations for db url
can you plese clearly tell me what my database url should look like ?
my db1 access program is already registered in system DSN and its name is  db1.
it doesn't need any access user id or psswords
i used all the defaults in setting up  jdbc odbc bridge program
below is my java code related with class loading and connection:
there mustn't be any syntax error or any mistake related with java because it can compile
thanks for your taking time to help me
regards :)
 public void init() throws ServletException {
    try {
  Class.forName("easysoft.sql.jobDriver");
    }
    catch (Exception e) {
      throw new UnavailableException(
      "Failed to fetch a connection pool from the context: " + e.getMessage());
    }
  }
....
    try {
      con = DriverManager.getConnection("jdbc:easysoft:db1");
      stmt = con.createStatement();
      rs = stmt.executeQuery(select);
         while (rs.next()) {
......
}
 
 
 
java.sql.SQLException: [JOB] Connection failed General error: No license slots available

        at easysoft.sql.jobDriver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:517)
        at java.sql.DriverManager.getConnection(DriverManager.java:199)
        at gs.printMessages(gs.java:79)
        at gs.doGet(gs.java:39)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:748)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
        at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
        at org.apache.tomcat.core.Handler.service(Handler.java:287)
        at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
        at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
        at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
        at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
        at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
        at java.lang.Thread.run(Thread.java:484)

Reply via email to