Error:java.sql.SQLException: Data source name not found

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vinothvit
    New Member
    • Nov 2011
    • 1

    Error:java.sql.SQLException: Data source name not found

    error:java.sql. SQLException: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    above error is shown,

    i have used oracle10g as database

    my code:
    Code:
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          
             Connection con=DriverManager.getConnection("jdbc:odbc:XE","SYSTEM","system");
       
    	
                            Statement st=con.createStatement();
    	 ResultSet rs=st.executeQuery("select * from result");
    Last edited by Niheel; Dec 19 '11, 04:15 PM.
  • kuldeeprsks
    New Member
    • Dec 2011
    • 22

    #2
    after creating DSN test your connection first then compile your code and run.

    Comment

    Working...