SQL Server Driver for ODBC

Lifeboat can install the libtdsodbc.so driver for connecting to Microsoft SQL Server with ODBC.

There is an example project built into this user guide that illustrates how to connect to a SQL Server database using SQLDatabaseMBS. Unfortunately, efforts to connect with the built in ODBCDatabase class were unsuccessful.

Example project: sqlserver-connect.xojo_xml_project - 32kb
(Right-click and "Save as..." when reading offline)

Install SQL Server on Linux

Microsoft provides installation instructions for Microsoft SQL Server on Ubuntu (and therefore, Debian) Linux. An up-to-date link to the Microsoft documentation is available here: <https://strawberrysw.com/lifeboat/sql-server>