hi i m trying to make connection with the ms sql from last two days
i have downloaded the ms driver and set the class path and all both in system and ide ie netbeans
but i m facing this problem
my code
Java Code:
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package databasedemo;


import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author Admin
 */
public class DataBaseDemo {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        try
        {
//            Class.forName("sun.jdbc.odbc.jdbcodbcDriver");
             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//            Connection con = DriverManager.getConnection("jdbc:odbc:my");
             String connectionUrl = "jdbc:sqlserver://localhost" +
   "databaseName=emp" + "user=sa" + "password=password@123";
//            Connection con = DriverManager.getConnection("jdbc:odbc:my//localhost:5000" , "sa" , "password@123");
             Connection con = DriverManager.getConnection(connectionUrl);
            Statement stat = (Statement) con.createStatement();
//            String str = "select * from emp";
            ResultSet rs = stat.executeQuery("select * from emp");


            while(rs.next())
            {
                System.out.println(rs.getInt("empid")+ "" + rs.getString(2));

            }
        }
        catch (ClassNotFoundException ex) {
            Logger.getLogger(DataBaseDemo.class.getName()).log(Level.SEVERE, null, ex);
        }        catch (SQLException ex) {
            Logger.getLogger(DataBaseDemo.class.getName()).log(Level.SEVERE, null, ex);
        }



    }

}
my error is
Java Code:
run:
20 Sep, 2011 8:09:28 PM databasedemo.DataBaseDemo main
SEVERE: null
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhostdatabaseName=empuser=sapassword=password@123, port 1433 has failed. Error: "null. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:171)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1033)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
        at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
        at java.sql.DriverManager.getConnection(DriverManager.java:582)
        at java.sql.DriverManager.getConnection(DriverManager.java:207)
        at databasedemo.DataBaseDemo.main(DataBaseDemo.java:36)
BUILD SUCCESSFUL (total time: 15 seconds)
so to make an connection please help me