Hello bmwork.

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:

$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}'],
];

Please let me know if this helps.

Best regards.

Hello Bartek.

It should be the same, as far as I know.

Have you tried changing this:

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

to this?

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

It should work if you change the setting.

Please let me know.

Best regards.

Good deal, Bartek.

Please let me know if everything turns up good.

Best regards.

Hey, thanks Bartek.

That's really useful. I appreciate the help!

If you have any further questions or issues, please feel free to reach out to us, and we'll gladly help.

Best regards!