Dec-03-2019, 01:17 PM
(Dec-02-2019, 06:51 PM)Denni Wrote: okay so how are you implementingThe connection via PuTTY established port forwarding over SSH so the in order to talk to SQL Server I need to establish connection to localhost at 1433 port (PuTTY is forwarding remote port on which SQL Server listens to localhost)
1) The PuTTY connection (which establishes the SSH connection to the database?)
2) The communication from the program to the database via the PuTTY connection
(Dec-02-2019, 06:51 PM)Denni Wrote: Also have you tested this as a standalone process without a Thread -- aka you run the program it talks to the database through PuTTY and gets a reply? Nothing complicated and no GUI just straight pythonYes I did and it works without problem. The only thing I have not tried is to establish port forwarding over SSH and then connection to SQL Server without GUI. However I guess it should also use threading.