Doc #63312 [NEW]: Missing documentation

From: Date: Fri, 19 Oct 2012 13:47:13 +0000
Subject: Doc #63312 [NEW]: Missing documentation
Groups: php.doc.bugs 
Request: Send a blank email to doc-bugs+get-8981@lists.php.net to get a copy of this message
From: raul dot 3k at gmail dot com Operating system: Windows PHP version: 5.3.18 Package: MSSQL related Bug Type: Documentation Problem Bug description:Missing documentation Description: ------------ --- From manual page: http://www.php.net/function.sqlsrv-connect --- I noticed that you don't really need to put the instance name in connection string. In my case (SQL Server 2008 R2 on Windows Server 2008 as database server, using a php 5.3.14 and Windows Server 2003 with IIS 6.0 as web server), this function don't let me put the instance name at string connection. It throws an error: Error Locating Server/Instance Specified. Test script: --------------- <?php // When I take the instance name off, it works. $serverName = "192.168.0.11\SVDCBD01"; $connectionInfo = array( "Database"=>"CorporeRM", "UID"=>"planilha", "PWD"=>"planilha"); $conn = sqlsrv_connect( $serverName, $connectionInfo); if( $conn ) { echo "Connection established.<br />"; }else{ echo "Connection could not be established.<br />"; die( print_r( sqlsrv_errors(), true)); } ?> Expected result: ---------------- Connection established. Actual result: -------------- Array ( [0] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => -1 [code] => -1 [2] => [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. [message] => [Microsoft][SQL Server Native Client 10.0]SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ) [1] => Array ( [0] => HYT00 [SQLSTATE] => HYT00 [1] => 0 [code] => 0 [2] => [Microsoft][SQL Server Native Client 10.0]Login timeout expired [message] => [Microsoft][SQL Server Native Client 10.0]Login timeout expired ) [2] => Array ( [0] => 08001 [SQLSTATE] => 08001 [1] => -1 [code] => -1 [2] => [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. [message] => [Microsoft][SQL Server Native Client 10.0]A network- related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. ) ) -- Edit bug report at https://bugs.php.net/bug.php?id=63312&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=63312&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=63312&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=63312&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=63312&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=63312&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=63312&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=63312&r=needscript Try newer version: https://bugs.php.net/fix.php?id=63312&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=63312&r=support Expected behavior: https://bugs.php.net/fix.php?id=63312&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=63312&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=63312&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=63312&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=63312&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=63312&r=dst IIS Stability: https://bugs.php.net/fix.php?id=63312&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=63312&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=63312&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=63312&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=63312&r=mysqlcfg

« previous php.doc.bugs (#8981) next »