Code:
Set OBJdbConnection = Server.CreateObject("ADODB.Connection")
OBJdbConnection.Open "mydb"
set Rs = Server.CreateObject("ADODB.Recordset")
sqlq  ="SELECT * from profile"
OBJDBConnection.execute(SQLQ)
I always see so many different ways of doing this. What are the problems with my waya. Should I have adopenrecordset and adlockoptimistic as parameters after my db connection is opened...like so...

OBJDBConnection.open "mydb", adlockoptimistick, adopenrecordset

thanks