Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009
    Posts
    1

    Unanswered: Connecting java and oracle--error

    I have installed oracle9i and now am trying to connect java to the database i have created.
    i have created DSN and Test was successful.
    But while executing the program i get error as java.sql.SQLException: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle
    on SQL_HANDLE_ENV failed

    and in my java program i have given

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    con=DriverManager.getConnection("jdbcdbc:mca","mca","mca");
    stmt=con.createStatement();

    how to solve this plse help....its very urgent

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Why don't you use the Oracle JDBC driver to connect to the Oracle database?
    ---
    "It does not work" is not a valid problem statement.

Posting Permissions

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