From replies to other tickets, it seems the next version will support multiple SQL data sources as well as MSSQL. This is great, because we recently purchased the product, set up a number of tables in the default database, and then realised that there can only be one mySQL connection!

Do you have a rough idea of a release date?

Hi Milan,

We've installed v2.3 and see that it includes MSSQL support.

However, what will happen to all our existing tables (which are currently stored in the local WP mysql db) after turning on the option to "Use separate connection" (see attached screenshot)?  

Do we have to set up a separate connection to the local WP mysql db?

How do we configure different data connections per existing table?

Thanks

So I've had a go at configuring a separate DB connection to an MSSQL database, but the plug-in will not connect.

The error message is "wpDataTables could not connect to mssql server. mssql said: Failed to get DB handle: could not find driver"

Did you implement MSSQL connection using the PDO_DBLIB driver? http://www.php.net/manual/en/ref.pdo-dblib.php

Because I am able to connect to the MSSQL server using sqlsrv_connect.

I had to manually edit the config/config.inc.php file to "activate" the sqlsrv driver (which was installed and working) instead of dblib (which I've tried to install but isn't working well on Ubuntu):

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

So now I'm finally able to add the custom connection!

Unfortunately, I can't get any SQL queries to work. I just get an error message: "No data fetched!"

I've worked out that Limit Rules are adding unrecognised elements to the MSSQL query:

    ... OFFSET 0 ROWS FETCH NEXT 10 ROWS ONLY

For now, I've got it working by commenting out:

// Add Limit Rule if Vendor is MSSQL
if ($isMSSql) {
    if ($msSqlParsedLimit) {
        $defaultOrder = isset($parsedQuery['ORDER']) ? '' : ' ORDER BY(SELECT NULL) ';
        $query .= $defaultOrder . $msSqlParsedLimit;
    }
}

(in class.wpdatatables.php)

Will keep exploring a better fix.