Connection To MS SQL From ASP Page

Can someone tell me why the following code isnt working .. i just want to connect and even read a database tuple to begin..the error i am gettin is as follows:

ADODB.Recordset error '800a0e7d'

The connection cannot be used to perform this operation. It is either closed or invalid in this context.

/MediaServer/test_connect.asp, line 23
----------------------------------------------------------------

<%

Set objConn = Server.CreateObject("ADODB.Connection")
Set objRS = CreateObject("ADODB.RecordSet")

objConn.Open "Driver={SQL Server};" & _
"Server=MEDIA1-47;" & _
"Database=pubs;" & _
"Uid=sa;" & _
"Pwd=12345;"
objRS.Open "Select * from authors"


objRS.close
objConn.close
set objRS = nothing
set objConn = nothing%>