var conn = new ActiveXObject("ADODB.Connection");
var cmd = new ActiveXObject("ADODB.Command");
var sqlQurey;
var connectionString = "Provider=SQLOLEDB.1; Data Source=" + exceptionDBServer + "; User ID=" + userID +
" ;Password=" + password + "; Initial Catalog=" + exceptionDB;
conn.open(connectionString);
sqlQurey = "DECLARE @return_value int exec @return_value=storedProName'" + pram1+ "','" + pram2+ "','" + pram3+
"','" + pram4+ "'," + pram5+ "," + pram6;
cmd.ActiveConnection = conn;
cmd.CommandType = 1;
cmd.CommandText = sqlQurey;
cmd.Execute();
cmd.close;
conn.close;

Assign the @return_value value to any hidden field in the page and then access the value through JScript

We are changing the issue type to “General Discussion�because you have not followed up with the necessary information. If you have more time to look at the issue and provide more information, please feel free to change the issue type back to “Question�by opening the Options list at the top of the post window, and changing the type. If the issue is resolved, we will appreciate it if you can share the solution so that the answer can be found and used by other community members having similar questions.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.