Create java connection to sql server 2008

Question

GOod day, I just learning java about 2 days from internet. Now, i'm trying to open connection with my database but i having a problem.

java.sql.SQLException: No suitable driver found for jdbc:sqlserver://192.168.0.222;user=sa;password=N4ughty123456

here is my script .

  private void kuybtnActionPerformed(java.awt.event.ActionEvent evt) {                                       
        String nameval = utext.getText();
        String passval = ptext.getText();
        String ipval   = iptext.getText();

        String dbURL = "jdbc:sqlserver://"+ipval+";user="+nameval+";password="+passval+"";
        Connection conn;
        try {
            conn = DriverManager.getConnection(dbURL);
        } catch (SQLException ex) {
            Logger.getLogger(Login.class.getName()).log(Level.SEVERE, null, ex);
        }
        if (conn != null) {
            System.out.println("Connected");
        }
    }

how can i fix this ? thanks in advance

Microsoft JDBC Driver for SQL Server

Elliott Frisch
– Elliott Frisch

2017-06-29 04:11:51 +00:00
Commented Jun 29, 2017 at 4:11 — Elliott Frisch
– Elliott Frisch, Commented Jun 29, 2017 at 4:11

André · Accepted Answer · 2017-06-29 05:15:16Z

1

as already mentioned the jdbc driver has to be on the classpath, also don't forget to close that connection.. like Closing Database Connections in Java

answered Jun 29, 2017 at 5:15

André

17213 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Create java connection to sql server 2008

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related