Query with recordset

Hello,

I am connecting to the database as following:
set con = server.createobject("adodb.connection")
con.open "connectionstring"
set rs = con.execute("select * from tablename")

I am able to display the records but if I want to give adopenstatic to the above connection, how can I do so?

Thanks in advance,
Uday.There are several ways of implimenting it, but below link coud give you start on that

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprocursortypex.aspsql