2. PHPRunner General questions
  3. No SQL Server driver found in your PHP settings.
This topic is locked

No SQL Server driver found in your PHP settings.

 		6/20/2018 9:09:56 AM
PHPRunner General questions
C
 chrisbee author

Hi - I usually connect to MYSQL databases - with no issues.

I have to connect to a MS SQL server and am getting the following error:-
No SQL Server driver found in your PHP settings.
BUT when I view it from the Local Browser (in PHPRunner) I see the correct information.
Any ideas?
Admin 6/21/2018

You need to enable SQL Server support in your PHP settings. There are multiple SQL Server connectivity options that PHP provides and you need to pick one depending on what OS do you use.
Here is an example for Windows and SQL Server driver from Microsoft:

https://docs.microsoft.com/en-us/iis/application-frameworks/install-and-configure-php-on-iis/install-the-sql-server-driver-for-php
Most web hostings will have it configured for you by default.
C
 		chrisbee author 6/21/2018



You need to enable SQL Server support in your PHP settings. There are multiple SQL Server connectivity options that PHP provides and you need to pick one depending on what OS do you use.
Here is an example for Windows and SQL Server driver from Microsoft:

https://docs.microsoft.com/en-us/iis/application-frameworks/install-and-configure-php-on-iis/install-the-sql-server-driver-for-php
Most web hostings will have it configured for you by default.


Awesome - thanks........ I am confused why the built site works from the local webserver and not from the hosted site.... but never mind.
So to be clear... the MSSQL SERVER is on a server in our office
The Page is hosted on a web hosting service.
I assume I need to get IT to make some changes to the MSSQL Server in our office? OR - is this something to do with where the page is hosted?
Thanks
Chris
C
 		chrisbee author 6/25/2018

[quote name='chrisbee' date='21 June 2018 - 05:11 PM' timestamp='1529601075' post='85240']
Awesome - thanks........ I am confused why the built site works from the local webserver and not from the hosted site.... but never mind.
So to be clear... the MSSQL SERVER is on a server in our office
The Page is hosted on a web hosting service.
I assume I need to get IT to make some changes to the MSSQL Server in our office? OR - is this something to do with where the page is hosted?
Thanks
Chris
I have moved the Hosting to digital ocean. Set up a new droplet with Apache and all of the correct settings - as published - (https://vandewalle.me/connect-to-ms-sql-server-in-php-on-ubuntu-linux-16-04-lts-with-microsoft-drivers/) and it STILL does not talk to the MSSQL...... why?