Connect to SQL Server from Linux, PHP

Question

I'm trying to connect to a SQL Server 2008 from a Linux,PHP (cPanel, Greengeeks.com).

Server admin says that he added the Linux server IP to Firewall and enabled TCP/IP connection, port is 1433.

But I still can't connect tot he server.

The Error message is:

SQLSTATE[01002] (null) (severity 9)

Connection script is:

 <?php
  try {
    $hostname = "999.999.255.239\INSTANCENAME";
    $port = '1433';    
    $dbname = "database";
    $username = "user";
    $pw = "pass";
    $dbh = new PDO ("dblib:host=$hostname;dbname=$dbname;","$username","$pw");
  } catch (PDOException $e) {
    echo "Failed to get DB handle: " . $e->getMessage() . "\n";
    exit;
  }

Please help

Have you installed the mssql driver for php on you Linux OS? — user671150
– user671150, Commented Oct 28, 2016 at 6:13
@Nurzhan yes I think I did, please take a look at the screenshot of my cPanel PHP Settings prntscr.com/czx7f3 — D.Shinekhuu
– D.Shinekhuu, Commented Oct 28, 2016 at 6:38

Vincent · Accepted Answer · 2016-10-28 06:22:43Z

1

Maybe you can var_dump( $dbh->errorCode() . ' ' . $dbh->errorInfo()); to help you knowing what's wrong with your connection. You know that is necessary to check error with your important steps.

answered Oct 28, 2016 at 6:22

Vincent

697 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Connect to SQL Server from Linux, PHP

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related