ASP connection with MS sql database

[ajit kumar]

Hi,
i am try to connect ASP with MSsql.But it gives error.My connection code is:

set conn=server.createobject("ADODB.Connection")
conn.ConnectionString="Provider=SQLOLEDB;Database= lib_database;uid=sa;pwd=abc"
set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from lib"
rs.open sql,conn,1,2

in this code ADODB.recordset give error.
Plz. try to solve this and suggest me.
Thank you.
Ajit kumar