When I tried to connect to external MS SQL SERVER and get an error: "wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - could not find driver"
Thanks for opening a new ticket. I'll just copy my response from there, and we can continue here:
You need to install and enable the SQLSRV driver on the server where the separate connection is. The FAQ document is for versions prior to 2.7, and you are correct, those lines of code are not there anymore because we've added the driver select-box.
If your separate connection is on Ubuntu, please take a look at this thread to see how you can install the SQLSRV driver on that server.
When I tried to connect to external MS SQL SERVER and get an error: "wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - could not find driver"
I was trying to modify the config.inc.php (as mentions in that article https://wpdatatables.com/faqmd/cant-connect-remote-mysql-database/) but in my file there are not such lines at all... I have shared hosting and found that file here https://prnt.sc/pz0g32
What should I do?
I of course tried different drivers but the result the same... :(
Hey Max.
Thanks for opening a new ticket. I'll just copy my response from there, and we can continue here:
You need to install and enable the SQLSRV driver on the server where the separate connection is. The FAQ document is for versions prior to 2.7, and you are correct, those lines of code are not there anymore because we've added the driver select-box.
If your separate connection is on Ubuntu, please take a look at this thread to see how you can install the SQLSRV driver on that server.
Please let me know.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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