PyQt5, QtSql: connection to database does not work

[deanhystad]

Connection names are used to manage connections, not to select a database. When you open a connection it first checks if there is a connection using the same name. If there is, it shuts down the existing connection before opening the new. If you ever want to have multiple connections open at the same time you'll need to provide unique names for each connection. I don't think this option is used often.