connecting to the database- any problems with this way?

[SmagO]

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