We have moved our forum to GitHub Discussions. For questions about Phalcon v3/v4/v5 you can visit here and for Phalcon v6 here.
  1. Home
  2. Database

Phalcon 3 and mssql server

Hi, i would like upgrade my phalcon to 3.0 and php to 7.0, but in my app i need connect to MSSQL server :( In 2.0.x version i use lib https://github.com/ToNict/phalcon-sqlsrv/ but after upgrade to 3.0 i have error

Declaration of Phalcon\Db\Adapter\Pdo\Sqlsrv::connect($descriptor = NULL) should be compatible with Phalcon\Db\Adapter\Pdo::connect(array $descriptor = NULL)

in changelog i don't seen any changes for PDO so I'm a bit confused. I wroted to "ToNict" but i don't know when he/she anserw. Have anyone idea what was changed or what i schould do to run this stuff?

Regards



145.0k

The class was changed as you see. You just need to add array before $descriptor in Phalcon\Db\Adapter\Pdo\Sqlsrv::connect. Perhaps do even more things. Phalcon don't really like mssql.



142
Accepted
answer
in reply to Wojciech Ślawski
edited Aug '16

you can simply add array argument type hint at line 38 in Phalcon\Db\Adapter\Pdo\Sqlsrv.php like this

public function connect(array $descriptor = null)

it will be fine because we always pass array so type hinting won't matter



7.6k

Hi, thanks for anserw. That work :) Another problem is no support for sqlsrv in php7 ;)



142
in reply to engsere

https://github.com/Azure/msphpsql/releases/tag/4.1.0

This driver is official and contributors are from Microsoft.

Hi, thanks for anserw. That work :) Another problem is no support for sqlsrv in php7 ;)



7.6k

Yeap, but this is for Windows, but i have Debian...



142

well..they have supported ubuntu15 and 16 not sure if that'll work with debian or not....



7.6k

Hi I checked few things and I solved it.

all i described: https://github.com/ToNict/phalcon-sqlsrv/issues/5

Thanks for helping guys :)



79.0k

On Debian/GNU, I'm using https://www.freetds.org and plain PHP PDO / dblib: https://php.net/manual/en/ref.pdo-dblib.connection.php

You just build ORM-like wrapper around it and voila.