CODEWITHSUNDEEP
phpsql-servermacoszend-frameworkpdo
softwareplay
softwareplay

Reputation: 1409

PDO-dblib mssql installation on a mac

I'm using zend framework, and I have to connect to a microsoft sql db 2005. I've installed all the needed packages through the packet manager (homebrew) following (this tutorial), I've successfully downloaded the version of php5.5 with pdo_dblib. Then the problem started.

  1. Is the php installation valid for Zend framework and zend studio too? Since, the error that I was getting when trying to connect to the db hasn't changed at all so there must be a mistake;

  2. When I run:

    php -i | grep -i pdo

The output is:

  API Extensions => mysqli,pdo_mysql,mysql
  PDO
  PDO support => enabled
  PDO drivers => mysql, sqlite
  pdo_mysql
  PDO Driver for MySQL => enabled
  pdo_mysql.default_socket => /var/mysql/mysql.sock => /var/mysql/mysql.sock
  pdo_sqlite
  PDO Driver for SQLite 3.x => enabled

So, where is my new installation with php 5.5 and pdo-dblib and mssql? I'm quite confused...

PS: I'm running OSX 10.9

Upvotes: 2

Views: 4877

Answers (1)

softwareplay
softwareplay

Reputation: 1409

I've found a tutorial which explains how to link the new version of php. Specifically what is interesting of it is in those two lines of code:

 nano ~/.bash_profile
 export PATH="$(brew --prefix josegonzalez/php/php55)/bin:/usr/local/bin:$PATH"

now the command:

 php -i | grep -i pdo

gives the following output (with pdo dblib):

 API Extensions => mysqli,pdo_mysql,mysql
 PDO
 PDO support => enabled
 PDO drivers => dblib, mysql, odbc, sqlite
 pdo_dblib
 PDO Driver for FreeTDS/Sybase DB-lib => enabled
 pdo_mysql
 PDO Driver for MySQL => enabled
 pdo_mysql.default_socket => /tmp/mysql.sock => /tmp/mysql.sock
 PDO_ODBC
 PDO Driver for ODBC (unixODBC) => enabled
 pdo_sqlite
 PDO Driver for SQLite 3.x => enabled

Upvotes: 1

Related Questions