Python Forum
Search Results
Post Author Forum Replies Views Posted [asc]
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Dec-02-2019, 06:51 PM)Denni Wrote: okay so how are you implementing 1) The PuTTY connection (which establishes the SSH connection to the database?) 2) The communication from the program to the data...
jan_pips GUI 25 10,857 Dec-03-2019, 01:17 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-27-2019, 04:23 PM)Denni Wrote: Okay so can you post your MUC so I can examine it -- or is the PuTTY stuff external to your code base? PuTTY is external stuff. Using your code and mine to establ...
jan_pips GUI 25 10,857 Nov-27-2019, 11:01 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-25-2019, 09:02 PM)Denni Wrote: 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 connec...
jan_pips GUI 25 10,857 Nov-26-2019, 05:14 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-25-2019, 09:02 PM)Denni Wrote: 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 connec...
jan_pips GUI 25 10,857 Nov-25-2019, 09:47 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

Denni. Thanks for your effort but I believe one thing is missing. Did you connect to SQLLite over SSH port forwarding because the clash between port forwarding over SSH and connection to database that...
jan_pips GUI 25 10,857 Nov-25-2019, 08:38 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-08-2019, 03:19 PM)Denni Wrote: Okay I tried to work with the above Class but you do not include the import statements you are using so there are a few objects that I cannot reference as I do no...
jan_pips GUI 25 10,857 Nov-24-2019, 11:49 AM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-12-2019, 08:31 PM)Denni Wrote: This leads me to ask is there a need to use the lower functionality of this library over its preferred default functionality? Or is this just an oversight due to ...
jan_pips GUI 25 10,857 Nov-12-2019, 11:37 PM
    Thread: display the contents of the table in descending order of the date
Post: RE: display the contents of the table in descendin...

(Nov-12-2019, 05:36 PM)Denni Wrote: That being said are you married to that designer and/or would you like to learn to code PyQt like it was meant to be coded -- which btw is just as quick once you ...
jan_pips GUI 14 7,088 Nov-12-2019, 06:27 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

Below full code import pymssql import sqlalchemy as ORM class dbhMSSQL(object): def __init__(self, config): self.dialect = "mssql" self.driver = "pymssql" self.username =...
jan_pips GUI 25 10,857 Nov-08-2019, 09:58 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-07-2019, 09:04 PM)Denni Wrote: Okay just to be sure because it sounds like you make A connection to the database and then perform queries via that connection as needed while maintaining that co...
jan_pips GUI 25 10,857 Nov-07-2019, 09:29 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-06-2019, 04:07 PM)Denni Wrote: Okay first these Database aspects should all be contained within their own Class that is its own file. (aka MyDatabaseClass.py) Then you just import that file in...
jan_pips GUI 25 10,857 Nov-07-2019, 08:17 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

What I am trying to achieve is to connect my application - that can be used by more than just one person - to host where there is the instance of SQL Server. For security reasons I am using SSH to con...
jan_pips GUI 25 10,857 Nov-05-2019, 10:19 AM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

I think I understand the concept but the point is I am not full-breed python developer (I am rather self-taught person) so I am afraid I do not quite get how should I implement this solution. Therefor...
jan_pips GUI 25 10,857 Nov-04-2019, 08:39 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: RE: SSH port forwarding and connection to SQL Serv...

(Nov-01-2019, 10:16 PM)Denni Wrote: You are using the QThread concept for this I will try and look at this later to outline a better cleaner approach to what you are trying to do -- but if you are s...
jan_pips GUI 25 10,857 Nov-01-2019, 11:28 PM
    Thread: SSH port forwarding and connection to SQL Server in separate threads freezes
Post: SSH port forwarding and connection to SQL Server i...

To begin with I have to say I was not sure where to put the question but it seems to be after all problem with QT Threading. I am trying to incorporate into the application the modules that connect v...
jan_pips GUI 25 10,857 Nov-01-2019, 05:44 PM

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020