- When Driver 'SQLSRV' is selected, this message appears: "wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE"[IMSSP]: This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64: https://go.microsoft.com/fwlink/?LinkId=163712 "
- When Driver 'ODBC' is selected, this other message appears: "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"
We have no preference for any specific Driver. As long as it works.
- Could you help us?
In advance, I already granted as Private in the next reply, temporary WP-Admin, cPanel and WHM credentials.
I never saw these specific errors before, to be honest with you.
-
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.
-
Usually, at this step i would say "If you're not sure how to install the drivers, please reach out to your hosting provider", but you already did that...
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.
-
All that being said, i will still reach out to senior colleagues to get a second opinion, perhaps they had experience with these kinds of errors, if they have any kind of additional advise.
As soon as they respond, i will report back with their input;
and i hope that in the meantime perhaps your hosting might find at least something useful from some of the information i pointed out above.
You should only select the driver from the dropdown if the connection doesn't work. The plugin detects the connection you selected (MSSQL, MySQL, PostgreSQL) and based on that it attempts to connect using the default driver for that type of database. If that doesn't work automatically, then you need to select a specific driver.
A hosting provider should know how to install drivers, I honestly don't know what to advise in this case other than maybe looking at changing the hosting provider if they're unable to install a driver.
If you have a Linux server, you can take a look at this thread on Stack Overflow. There are literally thousands of resources available for installing the PHP drivers, so the hosting provider should be able to do this without many issues.
I had to select an option from the dropdown list because it didn't work automatically.
Regarding your comment:
"A hosting provider should know how to install drivers, I honestly don't know what to advise in this case other than maybe looking at changing the hosting provider if they're unable to install a driver."
They don't work with MSSQL Databases.
I apologize for their technical limitation and not having enough budget to switch to a better one.
We can sincerely understand your position, and we would be happy to assist further,
but we only provide support when the issue comes from our plugin. ( and any additional advice with examples that we have, where possible)
This is, unfortunately, down to your hosting not being able to properly install and configure the drivers you need on the server...
We provide support for our plugin. Database access drivers should be installed either by you (end user) or the hosting provider. If the hosting provider you're using doesn't work with MSSQL databases, there's no way you'll be able to connect to a MSSQL database.
The only thing you could do in this case is to move on to another hosting provider, to be completely honest.
I appreciate your honesty and share the reciprocal truthfulness.
Let's be clear: "We provide support for our plugin."
1- The only reason to seek access to the MSSQL is to make better use of your Plugin. (Note that I mention 'DBLIB', 'SQLSRV' or 'ODBC' just because they are the Drivers that operate on WpDatatables.)
2- I'm a layman but I'm also very hardworking.
"Database access drivers should be installed either by you (end user) or the hosting provider."
As my hosting provider doesn't work with this, - Could you guide some threads or articles that would help me (end user) to complete this task specifically on MSSQL[separate DB connection]?
Somehow, I may not have communicated or been understood correctly the first time.
- But we really do not expect of your support staff to access our server and configure it.
Yes, i can see what you mean, it is a very tricky position when an issue is coming from "not properly installing or configuring something" that is outside of our plugin.
We always like to help and advise as much as possible, it is just, i guess, sometimes difficult to set "a limit" on how far we can go in those situations.
As you can see, i coordinated with senior colleagues who are more experienced with this, to find any examples or to direct you to useful resources along the way as much as possible.
-
Of course, i am very happy to see that you have resolved this.
But i will pass all of the feedback to our management and the developers, and they will do their best to create an extended documentation about separate connection troubleshooting.
Thank you for your patience and cooperation, as always.
And as you know, please don't hesitate to ask if you have any further questions or concerns.
I sincerely understand your position too. Rest easy about it.
If they create this mentioned suggestion of an extended documentation about separate connection troubleshooting, it will be a crown jewel for the technical support.
This expands boundaries of current tech orientations by providing (near) end-to-end guidance.
Even with my problem already solved, I believe that this solution would mean the world to other users.
I will certainly pass the feedback and all the details to the management and the devs Team, so they will do their best to extend the documentation to guide users as much as we can from our end.
Thanks again, and as you know, don't hesitate to reach out if you have any questions or concerns.
Hello,
I asked our hosting provider support to install the 'PDO_SQLSRV' so we can use MSSQL (separate DB connection) on wpDatatables.
They followed this tutorial of cPanel:
https://support.cpanel.net/hc/en-us/articles/360053132353-How-install-pdo-sqlsrv-to-connect-to-MSSQL-Servers
But it still fails to work.
- When Driver 'SQLSRV' is selected, this message appears:
"wpDataTables could not connect to mssql server. mssql said: There was a problem with your SQL connection - SQLSTATE"[IMSSP]: This extension requires the Microsoft ODBC Driver for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver for SQL Server for x64: https://go.microsoft.com/fwlink/?LinkId=163712 "
- When Driver 'ODBC' is selected, this other message appears:
"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"
We have no preference for any specific Driver.
As long as it works.
- Could you help us?
In advance,
I already granted as Private in the next reply,
temporary WP-Admin, cPanel and WHM credentials.
Thanks/Хвала!
Hi, Zeba
I hope you're well today.
I never saw these specific errors before, to be honest with you.
-
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.
-
Usually, at this step i would say "If you're not sure how to install the drivers, please reach out to your hosting provider", but you already did that...
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.
-
All that being said, i will still reach out to senior colleagues to get a second opinion, perhaps they had experience with these kinds of errors, if they have any kind of additional advise.
As soon as they respond, i will report back with their input;
and i hope that in the meantime perhaps your hosting might find at least something useful from some of the information i pointed out above.
Kind Regards,
Miloš Jovanović
[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 Zeba
You should only select the driver from the dropdown if the connection doesn't work. The plugin detects the connection you selected (MSSQL, MySQL, PostgreSQL) and based on that it attempts to connect using the default driver for that type of database. If that doesn't work automatically, then you need to select a specific driver.
A hosting provider should know how to install drivers, I honestly don't know what to advise in this case other than maybe looking at changing the hosting provider if they're unable to install a driver.
If you have a Linux server, you can take a look at this thread on Stack Overflow. There are literally thousands of resources available for installing the PHP drivers, so the hosting provider should be able to do this without many issues.
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
Dear Aleksandar,
I had to select an option from the dropdown list because it didn't work automatically.
Regarding your comment:
"A hosting provider should know how to install drivers, I honestly don't know what to advise in this case other than maybe looking at changing the hosting provider if they're unable to install a driver."
They don't work with MSSQL Databases.
I apologize for their technical limitation and not having enough budget to switch to a better one.
You also mentioned:
"There are literally thousands of resources available for installing the PHP drivers (...)"
This platform has rich content on many other subjects.
(Articles, videos and some of the best ticket answers I've seen.).
But the knowledge-base about installing and configuring MSSQL Drivers (for separate DB connection) is very scarce, poor and limited.
This scenario does not suit your company.
--
Don't get me wrong, but I'm a layman.
And that's why support and technical guidance is so important and essential to me.
For not being enough experienced,
I couldn't understand the thread on Stack Overflow you suggested.
That said, I share below some technical information from my server that maybe can help direct me to a better orientation.
- CentOS 7.9 + PHP 7.4 + cPanel + WHM.
(All credentials already previously available as well.)
--
I'm really sorry I didn't mention this server's info earlier.
I would like to reinforce being indifferent to any specific Driver.
- As long as it works, it could be 'DBLIB', 'SQLSRV' or 'ODBC' Driver.
Every help and support are much welcome²,
I share my gratitude;
(hope for the best.)
Hi, Zeba
We can sincerely understand your position, and we would be happy to assist further,
but we only provide support when the issue comes from our plugin. ( and any additional advice with examples that we have, where possible)
This is, unfortunately, down to your hosting not being able to properly install and configure the drivers you need on the server...
We provide support for our plugin. Database access drivers should be installed either by you (end user) or the hosting provider. If the hosting provider you're using doesn't work with MSSQL databases, there's no way you'll be able to connect to a MSSQL database.
The only thing you could do in this case is to move on to another hosting provider, to be completely honest.
Kind Regards,
Miloš Jovanović
[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
Miloš,
I appreciate your honesty and share the reciprocal truthfulness.
Let's be clear: "We provide support for our plugin."
1- The only reason to seek access to the MSSQL is to make better use of your Plugin.
(Note that I mention 'DBLIB', 'SQLSRV' or 'ODBC' just because they are the Drivers that operate on WpDatatables.)
2- I'm a layman but I'm also very hardworking.
"Database access drivers should be installed either by you (end user) or the hosting provider."
As my hosting provider doesn't work with this,
- Could you guide some threads or articles that would help me (end user) to complete this task specifically on MSSQL [separate DB connection]?
Somehow, I may not have communicated or been understood correctly the first time.
- But we really do not expect of your support staff to access our server and configure it.
(It wouldn't be fair and it's not your role.)
We've always been fine about it.
Хајде
As Aleksandar mentioned:
"There are literally thousands of resources available for installing the PHP drivers (...)"
I've shared the server's info credentials to make it easier to point the way.
- CentOS 7.9 + PHP 7.4 + cPanel + WHM.
--
In other words, any tips or guidelines that might lead to a better understanding.
( and any additional advice with examples that you have, where possible)
Regards,
Greetings,
Just letting you know that I managed to solve the problem.
I reiterate that contents related to installing and configuring the Drivers required to work separate connections on wpDataTables are very welcome!
It's not a problem with the Plugin.
But this current lack of related guidance content is an issue.
Since if not oriented all separate connections are unusable.
Thanks to support for their attention and intent, despite the limitations.
Regards,
Hi, Zeba
Sorry for another delay.
Yes, i can see what you mean, it is a very tricky position when an issue is coming from "not properly installing or configuring something" that is outside of our plugin.
We always like to help and advise as much as possible, it is just, i guess, sometimes difficult to set "a limit" on how far we can go in those situations.
As you can see, i coordinated with senior colleagues who are more experienced with this, to find any examples or to direct you to useful resources along the way as much as possible.
-
Of course, i am very happy to see that you have resolved this.
But i will pass all of the feedback to our management and the developers, and they will do their best to create an extended documentation about separate connection troubleshooting.
Thank you for your patience and cooperation, as always.
And as you know, please don't hesitate to ask if you have any further questions or concerns.
Kind Regards,
Miloš Jovanović
[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 Miloš,
I sincerely understand your position too. Rest easy about it.
If they create this mentioned suggestion of an extended documentation about separate connection troubleshooting, it will be a crown jewel for the technical support.
This expands boundaries of current tech orientations by providing (near) end-to-end guidance.
Even with my problem already solved, I believe that this solution would mean the world to other users.
--
Thank you for care and concern as well.
Hey, Zeba
Thank you for understanding.
No problem at all.
I will certainly pass the feedback and all the details to the management and the devs Team, so they will do their best to extend the documentation to guide users as much as we can from our end.
Thanks again, and as you know, don't hesitate to reach out if you have any questions or concerns.
Kind Regards,
Miloš Jovanović
[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