Koozali.org formerly Contribs.org

Adding extension to PHP - ODBC/MSSQL connection

Adding extension to PHP - ODBC/MSSQL connection
« on: April 20, 2021, 09:32:00 AM »
Hi,

I used php odbc / FreeTDS quite a bit in sme 9 and now trying to configure SME 10 so I can upgrade. I pull a little information from a MSSQL database and need to get a connection. After installing php-odbc and unixODBC as well as FreeTDS I have had no luck.

Currently getting "Call to undefined function odbc_connect()". Could someone point me in the right direction on how to add extensions correctly using the SME10 php-fpm setup?

Thanks,
« Last Edit: April 20, 2021, 10:19:55 AM by Bozely »

Re: Adding extension to PHP - ODBC/MSSQL connection
« Reply #1 on: April 20, 2021, 10:18:46 AM »
Managed to connect to the database via isql but php doesn't seem to see odbc
« Last Edit: April 20, 2021, 10:22:12 AM by Bozely »

Offline Jean-Philippe Pialasse

  • *
  • 1,648
  • aka Unnilennium
    • http://smeserver.pialasse.com
Re: Adding extension to PHP - ODBC/MSSQL connection
« Reply #2 on: April 20, 2021, 01:04:22 PM »
Code: [Select]
yum install php*-php-odbc
if still not working you might need a templates-custom to enabled it against non php5 version according google