MSSQL and yii2

Yii 2.0 General Discussions
1

Please I want to use Microsoft(mssql 2012/2014) with my yii2 application instead of mysql. Please How do I go about it.

2

Install PDO, configure DSN then use it as usual.

3

How do I instal PDO

4

Depends which OS your server is running.

5

On Ubuntu > 16.04




curl https://packages.microsoft.com/keys/microsoft.asc | apt-key add -

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-tools.list

curl https://packages.microsoft.com/config/ubuntu/16.04/prod.list > /etc/apt/sources.list.d/mssql-release.list

apt-get update

apt-get install mssql-tools

apt-get install unixodbc-dev


ln -sfn /opt/mssql-tools/bin/sqlcmd-13.0.1.0 /usr/bin/sqlcmd

ln -sfn /opt/mssql-tools/bin/bcp-13.0.1.0 /usr/bin/bcp


ACCEPT_EULA=Y apt-get install msodbcsql


apt-get install unixodbc-utf16

apt-get install unixodbc-dev-utf16


pecl install sqlsrv pdo_sqlsrv


echo "extension=/usr/lib/php/20151012/sqlsrv.so" >> /etc/php/7.0/apache2/php.ini

echo "extension=/usr/lib/php/20151012/pdo_sqlsrv.so" >> /etc/php/7.0/apache2/php.ini

echo "extension=/usr/lib/php/20151012/sqlsrv.so" >> /etc/php/7.0/cli/php.ini

echo "extension=/usr/lib/php/20151012/pdo_sqlsrv.so" >> /etc/php/7.0/cli/php.ini

My summary from:

https://www.microsoft.com/en-us/sql-server/developer-get-started/php-ubuntu

I just started using this recently. It’s great to be able to access SQL server from Linux without needing to mess with FreeTDS, etc.

6

Windows 8.1

7

For Windows you can get it from https://github.com/Microsoft/msphpsql/releases

8

You have spent more than a day on this, when you could have done this.

That’s not productive.

Not for you.

Nor anyone else.

9

THE PHP VERSION IS 5.6.15

pdo for php version 7 is not working

10

Then find a version for 5.6. It was somewhere around.

11

Thanks a lot. Problem solved