note 71349 added to function.mssql-connect

From: Date: Thu, 23 Nov 2006 14:50:39 +0000
Subject: note 71349 added to function.mssql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-120024@lists.php.net to get a copy of this message
Hi all, jcastromail at yahoo dot es Steve H lbowerh at netscape dot net munckfish.net are all talking about SQL Server 2005 Express Edition. I had a problem with it too. It was a pain to make it working. If you run into a trouble, follow their advices and maybe these three: try port 1221 play with the SQL Server Configuration Manager play with the SQL Server Surface Area Configuration there are many options which may affect this working or not. All you ge is a general message: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied. (severity 9) I finaly maked it work with: $host = 'MACHINENAME'; // see? without \SQLEXPRESS $port = 1221; php.ini: mssql.secure_connection = On ntwdblib.dll: version = 2000.80.194.0 after playing with the configuration tools (enable TCP, and some...). I can't say if playing with cliconfg has any effect. HTH, Robert. ---- Server IP: 212.24.129.110 Probable Submitter: 62.84.154.56 (proxied: 1.1 ISA-SERVER) ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/71349 Del: integrated -- https://master.php.net/note/delete/71349/integrated Del: useless -- https://master.php.net/note/delete/71349/useless Del: bad code -- https://master.php.net/note/delete/71349/bad+code Del: spam -- https://master.php.net/note/delete/71349/spam Del: non-english -- https://master.php.net/note/delete/71349/non-english Del: in docs -- https://master.php.net/note/delete/71349/in+docs Del: other reasons-- https://master.php.net/note/delete/71349 Reject -- https://master.php.net/note/reject/71349 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#120024) next »