Se usi la group by devi specificare le colonne.

codice:
sql = "SELECT ip FROM log WHERE robot = 0 and ora >='" & OraSql & "' GROUP BY ip;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.CursorLocation=3
rs.Open sql, conn