PHP SQL Server Couldn't connect

Question

I want to ask you about how to connect to MSSQL Server 2005 using PHP?

I got error like this :

Connection could not be established. Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) )

and here is my PHP code :

<?php
    $serverName = "192.168.183.249\MSSQLSERVER, 1542"; //serverName\instanceName, portNumber default is 1433)
    $connectionInfo = array( "Database"=>"SEI_AproCS", "UID"=>"sa", "PWD"=>"");
    $conn = sqlsrv_connect( $serverName, $connectionInfo);
    if( $conn ) {
     echo "Connection established.<br />";
    }else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
    }
?>

Please help to advice.

THanks

Duplicate of stackoverflow.com/questions/18589942/…

Cees Timmerman
– Cees Timmerman

2014-10-09 08:16:25 +00:00
Commented Oct 9, 2014 at 8:16 — Cees Timmerman
– Cees Timmerman, Commented Oct 9, 2014 at 8:16

Samy Massoud · Accepted Answer · 2013-11-12 08:27:20Z

2

You just need to install driver from this link PHP Driver

You can follow this link for tutorial PHP MSSQL Tutorial

An other option is to connect to mssql using DSN ,
and this easy way you just to enable mssql extension in php

And follow this link to create DSN Create DSN in windows

Also follow this link to connect using php and DSN Connect php using DSN

edited Nov 12, 2013 at 8:27

answered Nov 12, 2013 at 8:17

Samy Massoud

4,3852 gold badges37 silver badges50 bronze badges

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

4 Comments

Kongkow Over a year ago

I just followed that step and still can't connect :(

Samy Massoud Over a year ago

is mssql local at your machine ? and do you have to use this method ?

Kongkow Over a year ago

I using php_sqlsrv_54_ts.dll, not mssql. I have tried using mssql but for PHP 5.4 cant

Samy Massoud Over a year ago

@Kongkow see the new edits , and don't forget to install mssql server at your local machine if you use local mssql database .

Nikul · Accepted Answer · 2013-11-12 08:39:25Z

1

To connect with sql server you need to add dll file for sql server in the directory

wamp\bin\php\php5.3.0\ext

answered Nov 12, 2013 at 8:39

Nikul

1,0251 gold badge13 silver badges33 bronze badges

Comments

Cees Timmerman · Accepted Answer · 2014-10-08 15:22:28Z

1

Try PDO:

//$pdo = new PDO("sqlsrv:Server=$hostname;Database=$dbname;", $username, $password);  // works with proper driver for PHP.
$pdo = new PDO("odbc:Driver={SQL Server};Server=$hostname;Database=$dbname;", $username, $password);  // works with proper driver for ODBC and PHP ODBC.

I could not get the first line to work due to weird compiler version incompatibilities, but the second one worked fine after installing Microsoft ODBC Driver 11 for SQL Server

PHP Version 5.3.0 has built-in ODBC support, according to php.ini, but that still lists an active extension=php_pdo_odbc.dll here.

answered Oct 8, 2014 at 15:22

Cees Timmerman

20.3k11 gold badges99 silver badges138 bronze badges

Comments

chaerul · Accepted Answer · 2016-09-09 10:55:27Z

0

You instal driver. ODBC

msodbcsql_x64.msi #System Operation 63
msodbcsql_x86.msi #System Operation 86/32

link download https://www.microsoft.com/en-us/download/details.aspx?id=36434

good luck

answered Sep 9, 2016 at 10:55

chaerul

1

Collectives™ on Stack Overflow

PHP SQL Server Couldn't connect

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

4 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related