Okay
  Public Ticket #2165540
CONECTION MSSQL
Closed

Comments

  • JULIO OQUENDO started the conversation
    I could not make the separate connection to sqlserver, I have installed wordpress in windows server 2016 iis. I have activated the wp datatables license, I think I install the sqlserver driver for php, I need documentation about it. wordpress and mssql are on the same server. thank you
  •  2,572
    Aleksandar replied

    Hello JULIO.

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

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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