Hi THANHHAI LE

Thanks for reaching out to us.

-

You can connect the plugin to almost any MySQL, MSSQL, and PostgreSQL database using the Separate DB Connection section in wpDataTables, 

if you correctly input the details for the connection.

You first have to check if you have the following drivers installed, and activated.

These drivers need to be installed and activated on the server where your WordPress website is. 

After you install and activate those drivers, it should work.

If you're not sure how to install the drivers, please reach out to your hosting provider.

The server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHPs logic of connecting to separate connections.

 If there are errors your server returns, those are returned by the server, and only displayed by wpDataTables

 - there's no additional log within wpDataTables that would distinctively show you what's behind the error.

-

You can actually test the full features of our plugin, and test your remote DB connection on our Demo sandbox on this link,

if it is on a live server ( if it is localhost, then It can't be accessed)

and there is a 15-day money-back guarantee period, So if you purchase the plugin, you can safely fully test it out, and if it doesn't fit your needs you can request and receive a refund in that period. ( same goes for all plugins and add-ons)

-

I am just not 100% sure about server-side processing for MSSQL.

We will check this with our 2nd level Team and we will report back to confirm this for you as soon as they respond.

Thank you for your patience.

Hi THANHHAI LE

I am happy to confirm that you will be able to use server-side processing for MSSQL as well, our developers confirmed it.

Can you please tell us, where did you find that statement : 

"Server side processing is available only for MySQL-based tables",

so that we can change it, i presume you found it somewhere in our Documentation pages?

Thank you

Hi THANHHAI LE

Just following up on this.

We have found the part of the documentation with the statement and have now changed it,

now it says "Server-side processing is available only for tables saved in the database (SQL tables)".

Thank you for pointing that out,

and let me know if you have any additional questions.