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

Problems connecting to mssql

Hi,

I am using the library at https://github.com/fishjerky/phalcon-mssql

I have problem connecting to the mssql server.

( ! ) Strict standards: Declaration of Twm\Db\Adapter\Pdo\Mssql::executePrepared() should be compatible with Phalcon\Db\Adapter\Pdo::executePrepared(PDOStatement $statement, array $placeholders, $dataTypes) in C:\localhost\app\vendor\mssql\db\adapter\Mssql.php on line 10

My steps of integration.

1) Add namespace in config/loader.php

2) Register db to di in services.php

    $di->set('db2', function() use ($config) {
    $dbclass = 'Twm\Db\Adapter\Pdo\\' . 'Mssql';
    return new $dbclass(array(
        "host"     => 'myip',
        "username" => 'username',
        "password" => 'password',
        "dbname"   => 'dbname'
    ));
});

3) Got the error when i tried to var_dump() $this->di->get('db2') in a controller.

Any help appreciated.



77.7k

The MSSQL library is not compatible with the version of Phalcon you're using. As the Github readme states:

Requirements :
- Phalcon >= 1.2.0 and <=1.3.x

Upcoming Release :
- Phalcon 2.0 support


27.8k
in reply to Lajos Bencz

thanks! do you know of any mssql driver for phalcon 2.0 + ?

The MSSQL library is not compatible with the version of Phalcon you're using. As the Github readme states:

Requirements :
- Phalcon >= 1.2.0 and <=1.3.x

Upcoming Release :
- Phalcon 2.0 support


77.7k

Nope, but you could try forking the existing project and implementing the necessary changes. The problem you've written is caused by mismatching method declaration, fixing it should be fairly easy:

https://github.com/fishjerky/phalcon-mssql/blob/master/test/app/library/db/adapter/Mssql.php#L276

https://github.com/phalcon/cphalcon/blob/880b4fde422c1e7a112d5546e274d12f6784442a/phalcon/db/adapter/pdo.zep#L184

public function executePrepared(\PDOStatement $statement, array $placeholders, $dataTypes)

I'm not too familiar with the changes between Phalcon 1.3 and 2.0, there might be more errors along the way.



306