Hi, Rees 

Thanks for reaching out tous

Can you please 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 fine.

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.

Hi, Rees 

That is correct.

Firstly when you input all the relevant remote connection details,  into the "Separate DB connection" tab, 

you can Test if the connection between wpDataTables and the remote database works, by clicking on the 'Test connection'.

If you successfully connected to your separate database, now when you create a new table you will have an option to choose which database will be used for creating the new tables.

( and you can set the remote table as the default choice, if needed)

-

Let me know if you have any questions