Hello and thanks in advance for any insight the community can provide. I'm working on a WordPress site hosted on GoDaddy's Business Launch Hosting Plan, so it's a Linux environment. The challenge I have is with trying to use a SQL query to display data from an external MS SQL server to the WordPress site.
When I started looking into this, I wanted to use a plugin (WPDataTable) to do this. I cleared one error when trying to connect to the server by enabling pdo_sqlsvr. Then I received the following error:
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 13 for SQL Server to communicate with SQL Server. Access the following URL to download the ODBC Driver 13 for SQL Server for x64: http://go.microsoft.com/fwlink/?LinkId=163712
I called GoDaddy to see how to resolve the error. They said our website would need to be hosted in their Windows environment (Plesk) in order to communicate with a MS SQL server, otherwise, I'd have to export data from MS SQL to i.e., CSV to then import to MySQL.
- Someone today (not godaddy) said there's potentially an option if I had root access to set up Microsoft’s freetds configuration, which I'm pretty sure I don't have through Godaddy (we're not on the VPS hosting plan) and this goes beyond my level of expertise.
- I'm assuming that whether attempting to do this with a plugin, or writing code, MS SQL server just doesn't communicate with websites hosted in a Linux environment.
The amount of data I need to query is relatively small, up to 100 records a month, updated a few times a month, with 5 or 6 columns of text related to short news articles and promotions along with links to PDF files associated with each record, the goal was to have the records update automatically on the website as data on the MS SQL server updated.
The version of PHP we're on with GoDaddy is PHP version: 7.2
(Lastly, I've been doing so much reading/googling and talking to GoDaddy, I chose high priority because the issue is driving me a little batty, yikes, and thanks again. :)