Active server connection

When should i open a database connection in an asp application should i open a connection for every session start or open the connection in every page which require the database connection