database connectivey
Hi
I am facing a problem
i want to connect to database named cns in my server using connection string in jsp
: here is the code
===============================================
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
//Make the Connection to the database.
//Replace IP, Name, Username, Password to match your information.
java.sql.Connection connection=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://cnsserver:1433/cns","frsuser", "us3rfr5");
//Get SQL Statement.
//Replace TableName to your table's name.
java.sql.ResultSet rs=connection.createStatement().executeQuery("select * from deed");
===========================================
It gives me a error (invalid url )
and if i remove the databse name "cns " then i get a error
"invalid table name "
please suggest what to do
