Hi, why do I need a native client or ODBC driver when I already got this driver > installed in my system. You need the Native Client on top of the PHP driver. The PHP driver implements functions that enable PHP to talk to SQL Server through the Native Client. HTH Kind regards/met vriendelijke groet, Serge Fonville http://www.sergefonville.nl Convince Microsoft! They need to add TRUNCATE PARTITION in SQL Server https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table 2012/9/5 Girish Talluru <girish.dev1986@xxxxxxxxx> > 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 >
