remote sqlsrv connection problem

[kanfur]

in .env

PHP_FPM_INSTALL_MSSQL=true
WORKSPACE_INSTALL_MSSQL=true

I have entered these commands

docker-compose build Nginx 
docker-compose restart //nginx mysql adminer workspace

and then I entered in my workspace container

I have a command like this;

`

       try { DB::connection("sqlsrv")->getPdo();
        echo( "\nConnected successfully to: (sqlsrv) " . DB::connection("sqlsrv")->getDatabaseName());
   
    } catch (\Exception $e) {
        die("\nCould not connect to the database. Please check your configuration. error:" . $e->getMessage() );
    }`

It gives an error:
Could not connect to the database. Please check your configuration. error:could not find driver

my .env db credientials

SQLSRV_DB_HOST=********.database.windows.net
SQLSRV_DB_DATABASE=***dbname
SQLSRV_DB_USERNAME=***username
SQLSRV_DB_PASSWORD=***password

Context information:

Output of git rev-parse HEAD

833c57a6b68b912a146378c0e112c1d2bd234888

Output of docker version

Docker version 20.10.6, build 370c289

Output of docker-compose version

docker-compose version 1.29.1, build c34c88b2
docker-py version: 5.0.0
CPython version: 3.9.0
OpenSSL version: OpenSSL 1.1.1h  22 Sep 2020

System info: Mac, Windows or Linux. Include which disto/version

MacOS 11.2.3

[kanfur]

I run this command
apt-get install freetds-common freetds-bin unixodbc php7.3-sybase

error : Could not connect to the database. Please check your configuration. error:SQLSTATE[01002] Adaptive Server connection failed (********.database.windows.net:1433) (severity 9)

However, I have tried these code group:
`

    try{
         
        $hostname = "********.database.windows.net";
        $dbname = "********";
        $username = "********";
        $pwd = "********";
        $dbh = new PDO ("dblib:version=8.0;charset=UTF-8;host={$hostname};dbname={$dbname}", $username, $pwd);
    
    } catch (PDOException $e) {
        echo "Failed to get DB handle: " . $e->getMessage() . "\n";
        exit;
    }

`

Output is; passed

[stale]

Hi 👋 this issue has been automatically marked as stale 📌 because it has not had recent activity 😴. It will be closed if no further activity occurs. Thank you for your contributions ❤️.

[stale]

Hi again 👋 we would like to inform you that this issue has been automatically closed 🔒 because it had not recent activity during the stale period. We really really appreciate your contributions, and looking forward for more in the future 🎈.