How to populate the recordset for database connection using Javascript in ASP page ?

[pratibha patel]

Hello Everyone,

I am using Javascript in ASP page to connect to the database. I am not able to figure out where is the problem.
Gettting this error->

Error Type:
ADODB.Recordset (0x800A0E7D)
The connection cannot be used to perform this operation. It is either closed or invalid in this context.
/MyWeb/test.asp, line 12

My code is->

<%@ Language = JavaScript %>
<%
      var DBObj
      var rs
      var connectionString 
      var SqlStr = "SELECT * FROM MyTable"

      DBObj= Server.CreateObject("adodb.connection")
      connectionString = "Provider=SQLOLEDB.1;Password=myPwd;Persist Security Info=True;User ID=myId;Initial Catalog=MyDBName; DataSource=MyCompName\MyDBINSTANCE"
      DBObj.Open(SqlStr, connectionString, adOpenDynamic, adLockOptimistic);
      rs = Server.CreateObject("ADODB.Recordset");
      rs.Open (SqlStr, DBObj);
%>

Error occurring for last line while opening a recordset, I don't know what went wrong. Please help.
If someone could please guide me in the right direction I would greatly appreciate it.

Thanking You.