I’ve been tearing my hair out with this all weekend, and I’m hoping someone might have some clues to help me out. I have setup a SQL server database on Azure, and I want my Mac installation of LibreOffice Base (Version: 18.104.22.168) to connect to it.
I’ve installed Java (Version 8 Update 261) and have a JRE selected in LibreOffice (Oracle Corporation 1.8.0_261). Installed various ODBC drivers and can see them in the ODBC Manager, and have crated the relevant DSN for each. I’ve tried:
- Devart ODBC Driver for SQL Server 3.1
- Microsoft ODBC 13.1
- Microsoft ODBC 17
- freetds v1.2.3
When I try to connect in LibreOffice and test the connection, it fails.
Anyone have an ideas what I’m doing wrong?
Thanks in advance, your help is much appreciated.