MS SQL server connection problem.
| From: | Girish Talluru | Date: | Wed, 05 Sep 2012 09:56:42 +0000 |
| Subject: | MS SQL server connection problem. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-318995@lists.php.net to get a copy of this message | ||
Hi All,
I'm having problem while connecting to MS SQL server from my php program.
I tried downloading driver from Microsoft and changed php.ini file but it
is showing the following error.
This statement I used to connect.
$connect = mssql_connect("localhost", "PC6", "password");
This is the error message I got
Call to undefined function mssql_connect() in C:\wamp\www\Test\dbTest.php
Then I tried other one as shown below:
This statement I used to connect.
$connect = sqlsrv_connect("localhost", "PC6", "password");
This is the error message I got
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 ) )
It is asking to download a native client. but i have already downloaded a
driver at http://www.microsoft.com/en-in/download/details.aspx?id=20098
named SQLSRV30.EXE
why do I need a native client or ODBC driver when I already got this driver
installed in my system.
Please help me out with this guys. I'm new to this.
Thanks,
Girish Talluru