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.cre ateobject("ADOD B.Connection")
conn.Connection String="Provide r=SQLOLEDB;Data base=lib_databa se;uid=sa;pwd=a bc"
set rs=Server.Creat eObject("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