PDO dblib cannot connect with ip address as "host" parameter

Vote count:

0

I am trying to connect to a mssql db with dblib using the IP of the server as the host in the DSN.

With tsql, this works without any problem

$ tsql -S 192.168.56.101 -U .\user -P user

but in PHP this does not work.

$pdo = new PDO("dblib:host=192.168.56.101,1433;dbname=OtherC", '.\user', 'user');

The error I get is : Error : SQLSTATE[01002] Adaptive Server connection failed (severity 9)

asked 37 secs ago

user664004

21

PDO dblib cannot connect with ip address as "host" parameter