Nov-26-2019, 05:14 PM
(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 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 pieceUsing 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.