Help with "unable to connect to database" problem

[nash avin]

Hello All,

Like many others I have gotten into the problem os unable to "connect to the database".I did look into the forums , but could not get a suitable answer.

It would be great if someone helps me out in this very helpful forum.I am giving you the code I have so far written

/*** DatabaseConnection.java****/

 
public class DatabaseConnection {
private Connection con;
private Statement stmt;
ProfInfoBean profinfobean = null;

   
   public ProfInfoBean dataInsert(String course, String sem, String inst){
   try {
   
   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            con = DriverManager.getConnection ("jdbc :-o	 dbc:forminfo","","");
            
   stmt = con.createStatement();
   String sql ="insert into forminfo.proftable(course,semester,instructor)values('"+course+"','"+sem+"','"+inst+"')";
   stmt.executeUpdate(sql);
   //stmt.close();
   
   
   }catch(ClassNotFoundException cnfEx){
   System.err.println("Failed to load JDBC/ODBC driver.");
   cnfEx.printStackTrace();
   System.exit(1); //terminate program.
    }
   catch(SQLException sqlEx){
   System.err.println("Unable to connect to DB");// This is the place I am getting the error..
   System.err.println(sqlEx.getMessage());
   sqlEx.printStackTrace();
}
   finally {
   try {
   if (con!=null) con.close();
   }catch(SQLException e){System.err.println(e.getMessage());}
   }
   
   return profinfobean;
   
   }
}
 
 

/*** DatabaseConnection.java****/


Any help would be greatly appreciated.

Thanking in advance
AS

[Jeanne Boyarsky]

Nash,
Please don't post the same question multiple times.