webdsn

Active Member
Mar 4, 2018
35
2
8
Taiwan
cPanel Access Level
Root Administrator
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 ?
 
Last edited by a moderator:

webdsn

Active Member
Mar 4, 2018
35
2
8
Taiwan
cPanel Access Level
Root Administrator
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?
 

webdsn

Active Member
Mar 4, 2018
35
2
8
Taiwan
cPanel Access Level
Root Administrator
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
 

Attachments

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
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

Active Member
Mar 4, 2018
35
2
8
Taiwan
cPanel Access Level
Root Administrator
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

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello,

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