connection function using odbc with PDO OOP

[rpv_sen]

Hi

I am trying to connection my database ODBC using function.

I am getting an error Connection error: could not find driver

mycode is

<?php
class Database{

    // specify your own database credentials
    private $host = "servername";
    private $db_name = "databsename.schemaname";
    private $username = "username";
    private $password = "password";
    public $conn;

    // get the database connection
    public function getConnection(){

        $this->conn = null;

        try{
            $this->conn = new PDO("odbc:host=" . $this->host . ";dbname=" . $this->db_name, $this->username, $this->password);
        }catch(PDOException $exception){
            echo "Connection error: " . $exception->getMessage();
        }

        return $this->conn;
    }
}
?>

Please help me to fix the issue.

[pritaeas]

Did you check if you have an ODBC driver for the database you are trying to connect to?

[rpv_sen]

Yes. if i check php.ini file. its shows odbc

[diafol]

What about in phpinfo() ?

[rpv_sen]

Its showing.

[diafol]

Which DB type are you using?

[rpv_sen]

MSSQL

[pritaeas]

Yes, the PHP PDO ODBC driver is enabled, but is there an actual MSSQL ODBC driver installed on your machine?

How to: Set Up an ODBC Data Source

[rpv_sen]

if i connect this by odbc_connect its working. but when i use PDO i am getting that error

[pritaeas]

ODBC does not connect to a host, but to a driver, see the discussion here:

http://stackoverflow.com/questions/20163776/connect-php-to-mssql-via-pdo-odbc

[rpv_sen]

Thanks, Now its working.

[diafol]

For the benefit of others out there, could you please show the solution?

[rpv_sen]

Here is the working code

<?php
class Database{

    // specify your own database credentials
    private $host = "odbc:Driver={SQL Server};server=servername;DATABASE=databasename";
    private $username = "username";
    private $password = "password";
    public $conn;

    // get the database connection
    public function getConnection(){

        $this->conn = null;

        try{
            $this->conn = new PDO($this->host, $this->username, $this->password);
        }catch(PDOException $exception){
            echo "Connection error: " . $exception->getMessage();
        }

        return $this->conn;
    }
}
?>