Hello hbgit.

Thank you for your purchase.

If your WordPress is hosted on Azure Web App Services you will need to modify the config.inc.php file, around line 65 find this line of code:

$wdtMsSqlDriver = [
'sqlsrv' => ['active' => false],
'dblib' => ['active' => true, 'version' => '7.0'],
'odbc' => ['active' => false, 'driver' => '{ODBC Driver 17 for SQL Server}'],
];

and change it to look like this:

$wdtMsSqlDriver = [
'sqlsrv' => ['active' => true],
'dblib' => ['active' => false, 'version' => '7.0'],
'odbc' => ['active' => false, 'driver' => '{ODBC Driver 17 for SQL Server}'],
];

Let me know if this helps.

If not, could you please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Best regards.

Hello again hbgit.

Unfortunately, there is nothing I can do to change it, even if I went in - I'm just be able to see the error.

Anyway, since this is a MSSQL, here's something from Microsoft:

"The Microsoft Drivers for PHP for SQL Server are PHP 5 extensions that allows for the reading and writing of SQL Server data from within PHP scripts. The release contains two drivers, the SQLSRV driver and the PDO_SQLSRV driver. The SQLSRV extension provides a procedural interface while the PDO_SQLSRV extension implements PDO for accessing data in all editions of SQL Server 2005 and later (including SQL Azure)"

Our plugin is using PDO_SQLSRV driver.

Can you please check if you have installed and enabled PDO extension (pdo_sqlsrv) on your server?

Best regards.

Hi Kent.

Our plugin requires minimum version of PHP 5.6, but we recommend updating to 7 or more.

Can we just confirm one more time that you've modified this file wp-content/plugins/wpdatatables/config/config.inc.php ?

$wdtMsSqlDriver = [
‘sqlsrv’ => [‘active’ => false],
‘dblib’ => [‘active’ => true, ‘version’ => ‘7.0’],
‘odbc’ => [‘active’ => false, ‘driver’ => ‘{ODBC Driver 17 for SQL Server}’],
];

and changed it to look like this:

$wdtMsSqlDriver = [
‘sqlsrv’ => [‘active’ => true],
‘dblib’ => [‘active’ => false, ‘version’ => ‘7.0’],
‘odbc’ => [‘active’ => false, ‘driver’ => ‘{ODBC Driver 17 for SQL Server}’],
];

Best regards.

Hi Kent.

Can you please check your server log and get back to me?

It's really strange that it tests good, and it still won't connect to it with the changes in config.inc.php.

Best regards.