Hi,

I've just installed wpDataTables 2.3. My WordPress is hosted on Azure Web App Services.

I've tried like EVERYTHING to get it working with MSSQL Server, but I coudn't. When I try to add a custom database in "Separate DB Connection", I get this error:

wpDataTables could not connect to mssql server. mssql said: Failed to get DB handle: could not find driver.

I'm not a developer, so a step-by-step would be apreciated.

Hi, 

I have enabled the PHP PDO ODBC extension, as well as PHP PDO SQLSRV. 

Here is a list of my enabled extensions: Array ( [0] => Core [1] => bcmath [2] => calendar [3] => ctype [4] => date [5] => ereg [6] => filter [7] => ftp [8] => hash [9] => iconv [10] => json [11] => mcrypt [12] => SPL [13] => odbc [14] => pcre [15] => Reflection [16] => session [17] => standard [18] => mysqlnd [19] => tokenizer [20] => zip [21] => zlib [22] => libxml [23] => dom [24] => PDO [25] => openssl [26] => SimpleXML [27] => wddx [28] => xml [29] => xmlreader [30] => xmlwriter [31] => cgi-fcgi [32] => mysql [33] => mysqli [34] => mbstring [35] => gd [36] => gettext [37] => curl [38] => exif [39] => xmlrpc [40] => xsl [41] => Phar [42] => soap [43] => pdo_mysql [44] => pdo_sqlite [45] => imap [46] => tidy [47] => wincache [48] => sqlsrv [49] => pdo_sqlsrv [50] => com_dotnet [51] => intl [52] => fileinfo [53] => pgsql [54] => pdo_pgsql [55] => PDO_ODBC [56] => mhash [57] => Zend OPcache )

I still can't get it working.

I was able to get it working after modifying the config.inc.php file, from:

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

to:

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