problem in connecting sql 2005

[shashi booshan]

Hi guys this is my program.I am using netbeans6 IDE and Microsoft sql driver for JDBC. I am trying connect to the SQL 2005 database.I have added the Driver in the application by right click in project ---> Properties -----> Add jar Files.

I am getting this Exception
"Exception No suitable driver found for jdbc.sqlserver://localhost:1433;databaseName=Project_Airways;user=sa;password=sql2005;
debug:
"

  
import java.sql.*;
public class Query {
 
    public static void main(String[] args) {
         ResultSet rs;
        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            String connection = "jdbc.sqlserver://localhost:1433;" +
            "databaseName=Project_Airways;user=sa;password=sql2005;";
            Connection con = DriverManager.getConnection(connection);
            Statement st = con.createStatement();
            String query = "select * from ARS_City";
            rs = st.executeQuery(query);
            while(rs.next())
            {
                System.out.println(rs.getString(2));
            }
        }
            catch(Exception e ) {
                System.out.println("Exception" + e.getMessage());
                
            }
        
    }
 
}
 

  

Is there anythin wrong in adding the Driver.Please let me know.
I am struck. Please help me.

Thanks


Regards
shashi

But when i run the progam through Netbeans IDE

[Shailesh Chandra]

Check the URL of connection string

String connection = "jdbc.sqlserver://localhost:1433;"

jdbc and sqlserver are separated by a . (dot), Use colon : instead.

String connection = "jdbc:sqlserver://localhost:1433;"


Shailesh