Can you please check do you have installed and enabled PDO extension (pdo_sqlsrv) on your server?
If your WordPress is hosted on Microsoft SQL Server that have drivers for PHP: SQLSRV extension or PDO_SQLSRV extension you will need to modify file wp-content/plugins/wpdatatables/config/config.inc.php and around line 65 find this line of code:
Hii cant connect my remote db via wpdatatables.
My wordpress server version is CentOS Linux 7.6.1810 (Core)
my remote mssql db version is ms sqlserver 2017
Hello Volkan.
Thank you for your purchase.
Our plugin is using PDO_SQLSRV driver.
Can you please check do you have installed and enabled PDO extension (pdo_sqlsrv) on your server?
If your WordPress is hosted on Microsoft SQL Server that have drivers for PHP: SQLSRV extension or PDO_SQLSRV extension you will need to modify file wp-content/plugins/wpdatatables/config/config.inc.php and around line 65 find this line of code:
and change it to look like this:
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables