how to connect java to sql server 2008?

Question

i want to connect java to sql server. this is my code :

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package javaapplication20;

/**
 *
 * @author HaMeD
 */
import java.sql.*;
import javax.swing.JOptionPane;

public class JavaApplication20 {

   public static void main(String[] args) 
    {
        DB db = new DB();
        db.dbConnect( "jdbc:jtds:sqlserver://HaMeD-PC:1433/Db_Test"," " ," ");
    }
}

class DB
{
    public DB() {}

    public void dbConnect(String db_connect_string, 
  String db_userid, String db_password)
    {
        try
        {
           // Class.forName("net.sourceforge.jtds.jdbc.Driver");
            String connectionUrl = "jdbc:sqlserver://HaMeD-PC:1433;DatabaseName=Db_Test;user=;Password=";
            Connection con = DriverManager.getConnection(connectionUrl);
           // Connection conn = DriverManager.getConnection(
   // db_connect_string, db_userid, db_password);
            System.out.println("connected");

        }
        catch (Exception e)
        {
           // JOptionPane.showMessageDialog(null, e.getMessage());
           e.printStackTrace();
        }
    }
//<editor-fold defaultstate="collapsed" desc="comment">




};
//</editor-fold>

and i dont have password for login in sqlserver. my error is:

 Login failed for user ''. ClientConnectionId:afdb6551-8788-4d80-9d93-e382aa5f77d7

please help me.

Acn · Accepted Answer · 2012-01-03 07:59:45Z

1

You are not joining SQL Server to Java .... You are connecting.

Secondly, the error message was from the sql server. This means the connection request was sent but the sql server refused to connect to that username/password. You can use windows authentication to connect in local machine. See documentation.

answered Jan 3, 2012 at 7:59

Acn

1,0762 gold badges12 silver badges22 bronze badges

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

1 Comment

hamed Over a year ago

((You can use windows authentication to connect in local machine.))but how use it?

Miguel Prz · Accepted Answer · 2012-01-03 08:01:59Z

0

you pass the "db_connect_string" String to "dbConnect" method, but you are not using it to connect to the db (perhaps you copy&paste your "connectionUrl" variable and didn´t adapt)

answered Jan 3, 2012 at 8:01

Miguel Prz

13.8k32 silver badges42 bronze badges

1 Comment

Andy Over a year ago

Yes, I was about to comment on that. I did a little looking, it looks like thats whats happening. He copy and pasted, but didn't tweak it correctly. From the connectinUrl, it doesn't look like the right parameters. I am pretty sure you need to take off "DatabaseName", "user", and "password" (and also actually put an actual username).

Collectives™ on Stack Overflow

how to connect java to sql server 2008?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related