At room temperature, CO2 has only weak dispersion intermolecular forces holding the molecules together. So, CO2 is a gas at room temperature. Whereas in SiO2, each Si-atom is linked with O-atom with single bond thus forming a network solid with high melting point. So, SiO2 is a solid.