3

i am using wamp server 2.5 and php 5.5.12 and SQL server 2014.

i am trying to connecting a php application . but its giving me an error to connecting a database

enter image description here

Doon
  • 19,719
  • 3
  • 40
  • 44
SAGAR MANE
  • 685
  • 2
  • 8
  • 23

1 Answers1

2

The MSSQL extension is not available anymore on Windows with PHP 5.3 or later. SQLSRV, an alternative driver for MS SQL is available from Microsoft: » http://www.microsoft.com/en-us/download/details.aspx?id=20098

Step by Step

  1. Download SQLSRV32.EXE (Microsoft Drivers for PHP for SQL Server) from: http://www.microsoft.com/en-us/download/details.aspx?id=20098

  2. Choose path: C:\xampp\php\ext

enter image description here

  1. Uncomment or Append extension = php_sqlsrv_55_ts.dll in php.ini

  2. Restart Apache from XAMPP Control Panel (Stop/Start)

I tested it and it works 100%

Leandro Papasidero
  • 3,728
  • 1
  • 18
  • 33
  • Hii @lea Tano : after fallow your steps now its giving me an error.. unable to load dynamic library 'C:\xamp\php\ext\php_mssql.dll' the specified module could not be found – SAGAR MANE Mar 11 '15 at 07:08
  • I read some articles and some people complained that some `XAMPP` versions do not contain the module dlls. Can you please let me know your `XAMPP` version, so I can test it myself. – Leandro Papasidero Mar 11 '15 at 14:05
  • xampp-win32-5.6.3-0-VC11-installer – SAGAR MANE Mar 11 '15 at 14:24
  • You were RIGHT. Thing had changed. Please follow my instructions. I downloaded `xampp win32-5.6.3` and tested it 100% Check my edited answer – Leandro Papasidero Mar 11 '15 at 21:05
  • I am also facing same issue.Could you please explain it for WAMP Server ? – kreya Sep 21 '15 at 06:16