Hi All,
Thanks for all the replies. I have found the solution myself.
import java.sql.*;
class ConnectMSSQLServer
{
public void dbConnect(String db_connect_string,String user,String password)
{
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
Connection conn = DriverManager.getConnection(db_connect_string,user,password);
System.out.println("---------connected-----");
CallableStatement strd_prod = conn.prepareCall("{call dbo.Stored_Procedure_name('param1','param2','param3',..)}");
int i = strd_prod.executeUpdate();
conn.close();
System.out.println(i);
}
catch (Exception e)
{
e.printStackTrace();
}
}
public static void main(String[] args)
{
ConnectMSSQLServer connServer = new ConnectMSSQLServer();
connServer.dbConnect("jdbc:sqlserver://Server_Name;databaseName=database_name","user_name","password");
}
}
If you have server name like myServer/Instance_name then you have to use escape characters like this
connServer.dbConnect("jdbc:sqlserver://Server_Name\\Instance_name;databaseName=database_name","user_name","password");
To get the JDBC driver follow the below link.
http://msdn.microsoft.com/en-us/sqlserver/aa937724[
^]
Thanks