msphpsql VS Adminer

Using the Microsoft github area for this, I grabbed the PHP shared library (.so) files for Debian 10. [Was this the right flavour to grab for Synology?]

I found this older post that links to a Github issue.

I did find this github issue where someone was unable to connect to SERVER\INSTANCE, closed as expected behavior. A response also said requests from Linux must be made over TCP and not UDP. The linked Microsoft documentation says as much, but is slightly confusing:

Step 1. Download the PHP driver here

Maybe follow the example code and put the password into a variable? https://github.com/microsoft/msphpsql/blob/master/sample/pdo_sqlsrv_sample.php

Just out of curiosity, what was it then? Because if I look at the (pdo)sqlsrv source, LOB's should be possible.

I think this might be the related open issue: https://github.com/microsoft/msphpsql/issues/1223

There is no problem with using MSSQL with PHP it's easily doable and supported. See the Microsoft open source extension: https://github.com/microsoft/msphpsql

Use adminer (or the SQL CLI) to verify tables and database entries. In a dockware default development setup: http://localhost//adminer.php (Server: 127.0.0.1, not localhost; database: shopware; initial login: root:root).

Heh, what a name for a DB explorer ("Adminer - Database management in a single PHP file"; Apache 2 or GPLv2 https://github.com/vrana/adminer/blob/v4.8.1/readme.txt#L7 )

Web Station test using PHP and Adminer via the 'ancient' unsupported pdo_dblib confirmed SQL Server is working, however I need to write code using the sqlsrv extension.

Or, more PHP now, do you have phpmyadmin or can run adminer - single file?

Nothing stops you from compiling everything into one file. Adminer does it.

Another solution I use often is Adminer, it is a single PHP file, working over web server and accessible from anywhere