As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

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,576
    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