Hello,
I know that it’s not possible out of the box, but can I connect manually with php to a Microsoft SQL Server database to read/write data with Kirby? This is way beyond my skills, and I am asking just to decide if this is something worth pursuing.
That doesn’t really depend on Kirby, because while you cannot use Kirby’s Database class, you can still use standard PHP PDO connections. But you need a driver.
Makes sense, thanks.
The website I am working on is currently on a hosting package that doesn’t allow installing Linux software such as the Microsoft SQL Server PHP drivers. If the need arises I will move it to better hosting, but the hosting provider’s support told me that ‘normally you can connect to a mssql database through odbc’. Is this a valid option? Where can I learn more?
Never done this, but worth a try: PHP: ODBC - Manual