note 70918 added to function.mssql-connect

From: Date: Sat, 04 Nov 2006 03:41:42 +0000
Subject: note 70918 added to function.mssql-connect
Groups: php.notes 
Request: Send a blank email to php-notes+get-119359@lists.php.net to get a copy of this message
Getting IIS working with SQL Server and PHP: 1. Put the updated ntwdblib.dll (version 8.00.194) in your C:\php5 directory (which should be in your PATH environment variable) 2. Set windows environment variable PHPRC=c:\php5 3. In php.ini: uncomment the 'extension=php_mssql' line and set the extension dir: extension_dir = "c:\php5\ext" 4. Under windows folder options uncheck the use simple file sharing checkbox 5. Make sure NTFS permissions are set properly for your web files under C:\Inetput\wwwroot for anonymous web access: IUSR_<COMPUTERNAME> (and IWAM_<COMPUTERNAME> if using the php CGI exe instead of the ISAPI extension under IIS). 6. Enable anonymous web access under IIS Directory Security 7. Use SQL Server and Windows Authentication mode for SQL Server (then create an SQL Server Login using SQL Authentication and a User mapping to that Login with db_reader role membership) Note that using fast_cgi and getting "No input file specified." can be solved by giving permission to IWAM_<COMPUTERNAME>, since it must launch a CGI process to render the file (bad generic error message...). ---- Server IP: 216.194.113.175 Probable Submitter: 68.81.130.211 ---- Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php Edit -- https://master.php.net/note/edit/70918 Del: integrated -- https://master.php.net/note/delete/70918/integrated Del: useless -- https://master.php.net/note/delete/70918/useless Del: bad code -- https://master.php.net/note/delete/70918/bad+code Del: spam -- https://master.php.net/note/delete/70918/spam Del: non-english -- https://master.php.net/note/delete/70918/non-english Del: in docs -- https://master.php.net/note/delete/70918/in+docs Del: other reasons-- https://master.php.net/note/delete/70918 Reject -- https://master.php.net/note/reject/70918 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#119359) next »