[PyQt] SSH port forwarding and connection to SQL Server in separate threads freezes

[jan_pips]

Okay but I first wanted to take this one bite at time and make sure we are on the same page as we move forward -- if what I provided creates a solid usable connection to an sqlite3 database on your end -- and then you can use this class to connect to your database (since I cannot duplicate that specific aspect) -- then we will have that base stuff in place -- and then can move to the next piece

Using the code you have provided I opened the connection to SQL Server database and was able to retrieve data from a table. Of course I have made some small modification (uncommenting import of SQLAlchemy and duplicating CheckConnection method so it fits SQL Server environment).

Nevertheless the connection has been established but one again I must underline that in order to do it I have created a SSH Tunnel using PuTTY and then forward the SQL Server port so the connection is to localhost:1433.