Wine + MSSQL + LibreOffice ++

[South Coast Software]

Hello all

My first post.

I am moving a business management system from a Windows-based environment to a Linux environment.

My existing Windows solution is a:
--- VB6.0 executable
--- MSSQL database
--- hosted on Windows Server 2012R
--- Reports are generated by creating instances of Excel workbooks/sheets, calling Macros inside and populating the requested reports using VBA.

I am attempting to move the entire solution to Linux Ubuntu.
--- MSSQL installed and functioning very well on Linux Ubuntu 18.04 LTS
--- Most database management done through SSMS on Windows 7 PC
--- 60 Excel templates converted to Libre Office ODT templates
--- Able to call macros in Libre Office templates and populate them from VB6.0 executable
--- Able to backup and restore SQL Server databases
--- VB 6.0 executable runs in Wine.

My problem is that I am testing at home, where I have a test Linux user machine which needs to run the Vb 6.0 exe in Wine 5.0 (done), and make data calls to a SQL Server instance located on my Windows 7 PC. I have network access from Ubuntu to Windows and vice versa.

It seems to me to be a network issue, where the Linux machine cannot 'see' the SQL Server instance on the Windows 7 machine? At work I was able to create a Wine-based ODBC connection to that Linux-based SQL server instance easily.

Earlier I installed SQL Server on the Linux machine and could 'manage' that instance from the Windows PC, but still could not access the SQL Server instance on the Windows PC from the Linux machine.

Any guidance would be appreciated.