Hola antigrondona, la propiedad State puede tomar estos valores:
Código:
stClosed -> Connection object is inactive and not connected to a database.
stOpen -> Connection object is inactive, but connected to a database.
stConnecting -> Connection object is in the process of connecting to a database.
stExecuting -> Connection object is currently executing.
stFetching -> Connection object is retrieving data from the database
Sacado de la ayuda.
Saluditos