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.
What is the link to the "guide" you referenced and what were the pdo libraries you had to install? I only see mysql in my PDO list using phpinfo() but don't know what apt-get commands to use to get the others. I'm using Ubuntu 20.04
If you are using sql server as an external DB, I suggest you to install the driver SQLSRV on the same server on which you have your wpdatatables project.
Important: the driver must be the php one, I mean compatible with PHP.
Once installed before making the external db connction test, try to verify through the driver that it can reach the DB correctly
Tim, if you don't know how to install the drivers on Apache, please reach out to your hosting provider. You can take a look at Microsoft's documentation on how to install SQLSRV on Ubuntu.
Hello,
I am trying to connect to a remote MS SQL DB and I followed through your guide:
- filled all of the gaps in remote connection settings
- allowed from remote DB side my IP address
But I receive the below error message:
"There was a problem with your SQL connection - could not find driver"
Hello Emanuele
Thank you for your purchase.
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.
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
The SQL server remote DB is installed on a remote virtual machine, different from the hosting where my wordpress project is located.
Drivers should be installed on the remote machine or in my wordpress one?
Drivers should bt installed all together or for a SQL Server connection the ODBC server is enought?
Hi again Emanuele
They should be installed on the server where your WordPress site is, because that's where our plugin is, which requires those drivers.
For MSSQL you need to install ODBC and SQLSRV.
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
Ok I succeded in the end.
I'm glad to hear that, Emanuele
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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
Emanuele,
What is the link to the "guide" you referenced and what were the pdo libraries you had to install? I only see mysql in my PDO list using phpinfo() but don't know what apt-get commands to use to get the others. I'm using Ubuntu 20.04
If you are using sql server as an external DB, I suggest you to install the driver SQLSRV on the same server on which you have your wpdatatables project.
Important: the driver must be the php one, I mean compatible with PHP.
Once installed before making the external db connction test, try to verify through the driver that it can reach the DB correctly
Thanks for the assistance, Emanuele
Tim, if you don't know how to install the drivers on Apache, please reach out to your hosting provider. You can take a look at Microsoft's documentation on how to install SQLSRV on Ubuntu.
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