You should be able to 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.
hi,
I am trying to use the “use separate Db” section to link my Azure SQL DB.
I have tried lots of options but I still get an error.
Do you have a help page for this? I can only find one for MYSQL.
I am happy to be guided by what works best with your software. I can adjust Azure easily.
Thanks.
Hi, Paul
Thanks for reaching out to us
You should be able to 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.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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