Doc #63312 [NEW]: Missing documentation
| From: | raul dot 3k at gmail dot com | 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