At this moment we are trying to connect wpdatatables with a sqlserver base, but we get an error related to the driver that is not found, we already activated it in cpanel but the same error continues to appear, I attach photos.
Shared servers usually don't allow remote access to databases, and I suppose that's what's causing the issue. Can you test the connection to a dedicated server's database?
Hello again Aleksandar, we have already changed to a dedicated server, the previous error no longer appears but another related one appears.
the new error is:
wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found
I was trying the solution you recommended but I have had no luck.
I want to be more specific, the server we have now works with CENTOS 7.8, I tried some terminal commands to install the driver but it still does not work.
We never worked with CENTOS, so I can't help you in that regard. Basically, the drivers need to be installed on the server where your WordPress site is. Here's the official documentation from Microsoft:
If this doesn't help you either, the only thing you can do is reach out to your hosting provider and hire one of their professionals to install the needed drivers on the server.
At this moment we are trying to connect wpdatatables with a sqlserver base, but we get an error related to the driver that is not found, we already activated it in cpanel but the same error continues to appear, I attach photos.
we don't know what else to do.
Hello Jeferson
Try enabling MySQL, PGSQL and DBLIB as well:
You don't really need "firebird", but the others need to be installed and activated in order to use external connections.
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
Hi! How are you?,
I have these items active, once if you need to activate more, or if I need to deactivate some
leave active the items you told me, but the same error appears.
What else can I do?
Hello again Jeferson
Can you provide me the connection details, so I can try connecting to the database?
This is a public ticket, so make sure to enable the PRIVATE response.
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
Estaba investigando y vi que el problema podía estar en el tipo de servidor.
nuestro servidor es compartido y, como vi, debemos tener uno dedicado. (server vps)
este puede ser el problema o no tiene nada que ver con eso?
That's probably it, Jeferson
Shared servers usually don't allow remote access to databases, and I suppose that's what's causing the issue. Can you test the connection to a dedicated server's database?
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
next week we will switch to a vps server, I will let you know how the process goes.
thank you very much
Hello again Aleksandar, we have already changed to a dedicated server, the previous error no longer appears but another related one appears.
the new error is:
wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE[01000] SQLDriverConnect: 0 [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found
what should I do?
Hello again Jeferson
I'm glad to hear the initial issue was resolved.
As for this new issue, it seems you don't have that driver installed. Please check the solution on git hub.
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
Hello Aleksandar, I hope you are well
I was trying the solution you recommended but I have had no luck.
I want to be more specific, the server we have now works with CENTOS 7.8, I tried some terminal commands to install the driver but it still does not work.
https://www.interserver.net/tips/kb/install-mssql-php-extension-whmcpanel-linux-server/
I did steps 1 and 2, but nothing :(
Do you know what more options I have to install the driver on the server?
Can you help me with this? These are unknown lands to me and I don't have much idea about Linux.
Hi again Jeferson
We never worked with CENTOS, so I can't help you in that regard. Basically, the drivers need to be installed on the server where your WordPress site is. Here's the official documentation from Microsoft:
https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15
If this doesn't help you either, the only thing you can do is reach out to your hosting provider and hire one of their professionals to install the needed drivers on the server.
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