PHP connection with SQL server

Question

SQL server connection shows error when using mssql_connect() or sqlsrv_connect() .Call to undefined function mssql_connect() or Call to undefined function sqlsrv_connect() error is displaying. In my server IIS and wamp server is running. can any one please help...

<?php $server = "localhost"; $user = "Administrator"; $pass = ""; $connectionInfo = array( "Database"=>"test", "UID"=>"$user", "PWD"=>"$pass"); $conn = sqlsrv_connect( $server, $connectionInfo); if( $conn === false ) { die( print_r( sqlsrv_errors(), true)); } ?> — user2986257
– user2986257, Commented Oct 11, 2013 at 11:35

Bastien D · Accepted Answer · 2013-10-10 08:20:00Z

1

"The MSSQL extension is enabled by adding extension=php_mssql.dll to php.ini."

For more information : MSSQL Installing/Configuring

answered Oct 10, 2013 at 8:20

Bastien D

1,4752 gold badges15 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2092317 · Accepted Answer · 2013-10-10 08:33:13Z

0

in the php.ini file remove the semicolon before the extention it will probably be in C:\xampp\php\php.ini enable your extention by removing the semicolon change this with

 ;extension=php_mssql.dll

with

 extension=php_mssql.dll

and restart your xampp

answered Oct 10, 2013 at 8:33

user2092317

3,3385 gold badges26 silver badges36 bronze badges

1 Comment

user2986257 Over a year ago

Iam running PHP in IIS server. I have also tried with WAMP server, but it shows the same error

Collectives™ on Stack Overflow

PHP connection with SQL server

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related