In the system requirements section of the PHPMaker help file, one of the requirements is •Microsoft SQL Server 2012 Native Client (for Microsoft SQL Server) to connect to SQL Server. This driver is deprecated. Is there another version I can install or does it have to be 2012?
ryansyt wrote:
This driver is deprecated.
Are you sure?
It is still the latest driver from Microsoft and it works for all newer versions of MSSQL.
Thank you. I installed the driver and when I generate and browse my website, the page only shows “mssqlnative extension not installed”.
You need to have Microsoft Drivers for PHP for SQL Server on your server: https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?view=sql-server-ver15.
I have the Native Client 2012, and the PHP drivers for MSSQL installed for the specified version of php. I am still getting the error “mssqlnative extension not installed”. I am not sure what to look at.
- You may have installed the wrong PHP driver for your PHP processor (e.g. 32/64bit, TS or NTS), double check.
- Read https://docs.microsoft.com/en-us/sql/connect/php/system-requirements-for-the-php-sql-driver?view=sql-server-ver15:
The correct version of the Microsoft ODBC Driver for SQL Server is required on the computer on which PHP is running.
- Check phpinfo() (see https://www.php.net/manual/en/function.phpinfo.php) and make sure the extension is loaded successfully. (You should see a “sqlsrv” section.)
thank you. I got it all installed properly. I was using the wrong dll. (nts instead of ts)