none
Sql Native client Probleme RRS feed

  • Question

  • Hello , the community of Sql Server.

    I've a problem with my Sql Native Client 2012 I want to install it for make working my php but that wont I've this error :

    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 ) ) 

    So I wanted to install SNC2012 (I've IIS 7 , SQL Server 2008 R2 Developper, Windows 2008 R2 x64 )

    I've this error : http://upload.gaming-box.net/pictures//1357002984.png

    I check the log and there is :

    Beginning a Windows Installer transaction: C:\Users\Administrator\Downloads\sqlncli.msi. Client Process Id: 15800.

    Product: Microsoft SQL Server 2012 Native Client  -- Installation failed.

    Windows Installer installed the product. Product Name: Microsoft SQL Server 2012 Native Client . Product Version: 11.0.2100.60. Product Language: 1033. Installation success or error status: 1603.

    Any one can help em ?

    Friday, January 4, 2013 3:12 AM

All replies

  • I suggest you simply type the error message into your post - completely.  Your link uses an unknown host (to me) and will undoubtably be blocked here.  Note that there are separate MSI files for 32bit and 64bit OSes - they use the same name so you need to install the correct one for your platform.   It also appears that you are using ODBC - if so it may help to be more explicit about your particular connection methodology.
    Friday, January 4, 2013 2:59 PM
  • I suggest you simply type the error message into your post - completely.  Your link uses an unknown host (to me) and will undoubtably be blocked here.  Note that there are separate MSI files for 32bit and 64bit OSes - they use the same name so you need to install the correct one for your platform.   It also appears that you are using ODBC - if so it may help to be more explicit about your particular connection methodology.

    upload.gaming-box.net is my own host , gaming-box is mine but I'll upload on image host :

    http://s9.postimage.org/md6orrvtb/1357002984.png

    I've try to instal the 32bits didn't work said me my Windows not compatible, and with the x64bits I've the problem which I posted you , and I use sqlsrv , this is my php script :

    function dbOpen($dbName) {
    			if (!$this->sqlLink) {
    				include_once("$this->config");
    				global $shardDbName;
    				global $accountDbName;
    				global $accountDbPWD;
    				global $mssql_server;
    				$db = array("Database"=>"$dbName", "UID"=>"$accountDbName", "PWD"=>"$accountDbPWD");
    				$this->mssql_server = $mssql_server;
    				$this->sqlLink = sqlsrv_connect($mssql_server, $db);
    				if (!$this->sqlLink) {
    					edie(print_r(sqlsrv_errors(), true));
    				}
    				
    				return;
    			} else {
    				exit;
    			}
    		}

    Friday, January 4, 2013 3:47 PM
  • I don't know how you specify the type of connection and the driver to use in PHP - but somewhere you need to specify the use of the appropriate native client version.  Multiple versions can coexist on the same machine. 
    Friday, January 4, 2013 4:40 PM
  • Hello,

    There is a forum dedicated to the MS driver for PHP.

    http://social.msdn.microsoft.com/Forums/en-US/sqldriverforphp/threads

    If you post your agreement, a moderator will move ASAP your thread towards this forum.Avantage : no thread to recreate,no lost post.

    We are waiting for your feedback to try to help you more efficiently.

    Have a nice day


    Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

    Thursday, January 10, 2013 3:22 PM
    Moderator