Yum install php-mssql

[jeetzz (Jeet)]

Hi

I am getting this error, when i hit “yum install php-mssql” I am will to change the script, but what do i go for in order to connect SQL Server Database 2008 R2…any ideas would be helpful.

   [root@freepbx ~]# yum install php-mssql
   Loaded plugins: fastestmirror, versionlock
   Loading mirror speeds from cached hostfile
   Resolving Dependencies
    --> Running transaction check
     ---> Package php-mssql.x86_64 0:5.4.16-9.el7 will be installed
   --> Processing Dependency: php(zend-abi) = 20100525-64 for package: php-mssql-5.4.16- 
   9.el7.x86_64
    --> Processing Dependency: php(api) = 20100412-64 for package: php-mssql-5.4.16- 
     9.el7.x86_64
      --> Processing Dependency: libsybdb.so.5()(64bit) for package: php-mssql-5.4.16-9.el7.x86_64
        --> Running transaction check
       ---> Package freetds.x86_64 0:0.95.81-1.el7 will be installed
        ---> Package php-common.x86_64 0:5.4.16-46.el7 will be installed
             --> Processing Dependency: libzip.so.2()(64bit) for package: php-common-5.4.16- 
           46.el7.x86_64
         --> Running transaction check
          ---> Package libzip.x86_64 0:0.10.1-8.el7 will be installed
            --> Processing Conflict: php56w-common-5.6.40-1.sng7.x86_64 conflicts php-common < 5.6
             --> Finished Dependency Resolution
            Error: php56w-common conflicts with php-common-5.4.16-46.el7.x86_64
             You could try using --skip-broken to work around the problem
          You could try running: rpm -Va --nofiles --nodigest

Appreciate your help.
Jeet

[BlazeStudios (Tom Ray)]

You install FreeTDS and use ODBC connectors to connect to the MSSQL database. You’re trying to install packages that have dependencies that conflict with the Sangoma packages and you’ll break stuff if you keep messing with it this way.

[jeetzz (Jeet)]

Thank you for replying, okay so I go ahead with this?

 yum install freetds
 yum install freetds-devel
 yum install --enablerepo=remi php-mssql

Right?

Jeet

[BlazeStudios (Tom Ray)]

No, I did not say install MSSQL for this. Just install FreeTDS and then use ODBC connectors to connect to the MSSQL via FreeTDS.

[jeetzz (Jeet)]

okay…