Sql Native client Probleme

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 ?

Answer 1

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.

Answer 2

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;
			}
		}

Answer 3

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. 

Answer 4

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.