以下建立connection对象的常用方法正确的是()

A.<% set bjrs = server.createobject("adodb.record")%>

B.<% dim bjrs = server.createobject("adodb.recordset")%>

C.<% set bjrs = objcn.execute( sql)%>

D.<% set bjrs =server.createobject("adodb.recordset")%>