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","m ca","mca");
stmt=con.createStatement();

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

Why don't you use the Oracle JDBC driver to connect to the Oracle database?