none
PHP drivers fro SQL Server not working RRS feed

  • Question

  • I've a Windows Small business Server 2011 Box. SQL Server 2012 is installed. I'm able to connect to the SQL Server by Windows Authentication using SQL Management Studio. I'm also able to create a system DSN using "Microsoft ODBC Driver 11 for SQL Server" and successfully connect to the SQL Server. I've 32-bit WAMP server with PHP5.5 installed. I've SQLSRV 3.0 (SQLSRV32) installed. 

    When I try to connect using php code (sqlsrv_connect) I get the following error.

    "Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft ODBC Driver 11 for SQL Server. Access the following URL to download the ODBC Driver 11 for SQL Server 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 ) )"

    Why is my SQLSRV not able t find the native client in C"\windows\system32 folder?

    Really appreciate your help!

    Friday, December 11, 2015 6:14 AM

All replies

  • refer following..

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/1ba3b5b5-d9cf-455c-abc7-01f10ef3ec9e/microsoftodbc-driver-manager-data-source-name-not-found-and-no-default-driver-specified?forum=sqlsetupandupgrade


    Please click Mark As Answer if my post helped.

    Friday, December 11, 2015 9:39 AM