I have a MS SQL database on azure. I added the appropriate IP addresses to allow the server in. I couldn't connect, "no driver found" then I went to php settings and added some sql drivers. I got different errors now but none of them connect, MSSQL, DBLIB etc.
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. In the screenshot where you enabled the drivers, I saw you enabled pdo_odbc, which should suffice, but the errors shown indicate as if no drivers are installed or that there are connection issues.
The server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHP logic for 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.
Did you restart the server when these drivers were enabled?
I changed the PHP version on cPanel along with the extensions, and I checked wordpress settings to verify the php version had changed. I was not able to restart apache, as I do not have root access, but I believe the cpanel configuration causes apache to reinitialize, as the php version does change when I save it. Also, I got different errors upon enabling these php extensions, leading me to believe there was some progress. However it seems there is some sort of mismatch between what Azure is expecting and what drivers are installed on my php version .
Perhaps there is additional things I could add to the class.connection.php to fix this?
I did add this string as I found in another ticket: TrustServerCertificate=True; Encrypt=false
wpDataTables only allows you to link separate databases, but it doesn't allow you to modify any settings.
Can you please access the "System Info" option in the WordPress menu and check the drivers you see in there?
If you don't see the needed driver, it's definitely what's causing the issue.
I am not aware of any changes that could be made in class.connection.php to fix this, since the separate DB connection has been a part of wpDataTables for a long time now, and it was never required to modify anything in this file in order for the connection to work. As mentioned before, wpDataTables only returns the responses from the external server, and that info is what your separate DB server is returning. The hosting provider where that server resides should be able to troubleshoot the issue based on those messages.
All the PHP plugins are installed but it seems when I try to use them, they fail because no Sql Server OBDC 17 driver is installed? which I found one on my server, but it didnt seem to be installed. When I used strings to call the driver by path/filename it *maybe* got further? but timed out. So. Still stuck
If yes - Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
I have a MS SQL database on azure. I added the appropriate IP addresses to allow the server in. I couldn't connect, "no driver found" then I went to php settings and added some sql drivers. I got different errors now but none of them connect, MSSQL, DBLIB etc.
Attached files: Screen Shot 2024-07-31 at 5.02.13 PM.png
Screen Shot 2024-07-31 at 5.01.58 PM.png
Screen Shot 2024-07-31 at 5.01.51 PM.png
Screen Shot 2024-07-31 at 5.01.33 PM.png
Hello Ike
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. In the screenshot where you enabled the drivers, I saw you enabled pdo_odbc, which should suffice, but the errors shown indicate as if no drivers are installed or that there are connection issues.
The server to which wpDataTables is connecting has its own method of establishing the connection, and we're using PHP logic for 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.
Did you restart the server when these drivers were enabled?
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
I changed the PHP version on cPanel along with the extensions, and I checked wordpress settings to verify the php version had changed. I was not able to restart apache, as I do not have root access, but I believe the cpanel configuration causes apache to reinitialize, as the php version does change when I save it. Also, I got different errors upon enabling these php extensions, leading me to believe there was some progress. However it seems there is some sort of mismatch between what Azure is expecting and what drivers are installed on my php version .
Perhaps there is additional things I could add to the class.connection.php to fix this?
I did add this string as I found in another ticket:
TrustServerCertificate=True; Encrypt=false
But it did not work
Its also possible I need to change my azure connection settings somehow. ?
Hi again Ike.
wpDataTables only allows you to link separate databases, but it doesn't allow you to modify any settings.
Can you please access the "System Info" option in the WordPress menu and check the drivers you see in there?
If you don't see the needed driver, it's definitely what's causing the issue.
I am not aware of any changes that could be made in class.connection.php to fix this, since the separate DB connection has been a part of wpDataTables for a long time now, and it was never required to modify anything in this file in order for the connection to work. As mentioned before, wpDataTables only returns the responses from the external server, and that info is what your separate DB server is returning. The hosting provider where that server resides should be able to troubleshoot the issue based on those messages.
Please check with them and let me know.
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
All the PHP plugins are installed but it seems when I try to use them, they fail because no Sql Server OBDC 17 driver is installed?
which I found one on my server, but it didnt seem to be installed. When I used strings to call the driver by path/filename it *maybe* got further? but timed out. So. Still stuck
Attached files: Screen Shot 2024-08-02 at 11.12.43 AM.png
Screen Shot 2024-08-02 at 12.31.56 PM.png
Hi again Ike.
Can we try adding a separate DB on your site?
If yes - Please provide me a temporary WP-admin (administrator) user for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue.
We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties.
You can write credentials here just check PRIVATE Reply so nobody can see them except us.
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