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
