sql server - Can't connect to MS SqlServer using php

Question

I am trying to connect to an external db which uses sqlserver but after trying many options couldnt find one that works at all.

    $connattempt1 = odbc_connect("Driver={SQL Server Native Client 10.0};Server=XXX.XXX.XXX.XX;1433;Database=IDD",'username','password');
    $connattempt2  = new PDO('sqlsrv:Server=XXX.XXX.XXX.XX,1433;Database=IDD','username','password');
    $connattempt3  = sqlsrv_connect('XXX.XXX.XXX.XX', [
            "Database"      =>      IDD, 
            "UID"           =>      'username',
            "PWD"           =>      'password',
            "CharacterSet"  =>      "UTF-8"
        ]);

I will be running this same code on several apache servers all of them on php7. Im looking for a way to connect without having to edit the php.ini on all servers or importing external libraries. Is there a standard way to correctly make this connection? Any clue, manual, tips, links are also welcome, thanks!

question from:https://stackoverflow.com/questions/66065127/cant-connect-to-ms-sqlserver-using-php

Answer 1

Waitting for answers