SOLVED Installing freetds error

[webdsn]

I follow this post try to install freetds

Definitive FreeTDS installation instructions

But in step 4

echo "--with-mssql=/usr/local/freetds" >> /var/cpanel/easy/apache/rawopts/all_php5

I don't find this file
/var/cpanel/easy/apache/rawopts/all_php5

I want to install ODBC driver
Connect to MS SQL server using PHP

Have anyone can help me ?

 

[cPanelMichael]

Hello @webdsn,

The thread you linked is no longer applicable with EasyApache 4. Can you revert the steps you've taken thus far and try using the steps reccomended on the following comment from our feature request website?

EasyApache 4 PDO_DBLIB (mssql support)

There's also a post here you may find helpful:

Can't make pdo_dblib to work

Thank you.

 

[webdsn]

Hello @webdsn,

The thread you linked is no longer application with EasyApache 4. Can you revert the steps you've taken thus far and try using the steps reccomended on the following comment from our feature request website?

EasyApache 4 PDO_DBLIB (mssql support)

There's also a post here you may find helpful:

Can't make pdo_dblib to work

Thank you.

Thank your reply Michael

When I checked the system, I found that my system has CloudLinux installed
ODBC module enabled in EasyApache4
Can that apply to CloudLinux's PHP?

 

[cPanelMichael]

Can that apply to CloudLinux's PHP?

Hello,

You can read more about the PHP extensions bundled with PHP Selector at:

PHP Selector > Bundled PHP Extensions > PHP 7.0 Extensions

It shows odbc, pdo_odbc, and pdo_dblib are included.

Thank you.

 

[webdsn]

Hello,

You can read more about the PHP extensions bundled with PHP Selector at:

PHP Selector > Bundled PHP Extensions > PHP 7.0 Extensions

It shows odbc, pdo_odbc, and pdo_dblib are included.

Thank you.

Thank your reply Michael
I already see this document
and I have install alt-php
But when I open php selector and use PHP 7.0
there is no pdo_sqlsrv and sqlsrv option inside
even I open CloudLinux LVE manager selector also don't see it

 

[cPanelMichael]

Hello @webdsn,

You should enable the "pdo_dblib" PHP extension for PHP version 7.0 with PHP selector. Once you do that, can you let us know the specific error message you receive when attempting to open the PHP page that makes the MSSQL connection?

Thank you.

 

[webdsn]

Hello @webdsn,

You should enable the "pdo_dblib" PHP extension for PHP version 7.0 with PHP selector. Once you do that, can you let us know the specific error message you receive when attempting to open the PHP page that makes the MSSQL connection?

Thank you.

Thank for your reply

This problem has been solved
The problem is again ODBC version is too old
After the update is resolved

Just because of some conflicting relationship, updating ODBC is tedious

 

[cPanelMichael]

Hello,

I'm glad to see the issue is now solved. Thank you for sharing the outcome.