Doc #74754 [NEW]: SQL Server Driver String Not Up to Date

From: henry at dotrose dot com Operating system: Linux PHP version: 7.0.20 Package: Documentation problem Bug Type: Documentation Problem Bug description:SQL Server Driver String Not Up to Date Description: ------------ --- From manual page: http://www.php.net/function.odbc-connect --- In the "Example #1 DSN-less connections" portion of the documentation, it says: // Microsoft SQL Server using the SQL Native Client 10.0 ODBC Driver - allows connection to SQL 7, 2000, 2005 and 2008 $connection = odbc_connect("Driver={SQL Server Native Client 10.0};Server=$server;Database=$database;", $user, $password); This does not work with recent installations of unixODBC. It returns a unixODBC error message saying Driver Manager "cannot open lib 'SQL Server Native Client 10.0' : file not found". Rather than changing the Driver string, however, I suggest adding something that helps the user find the correct current value. By looking in /etc/odbcinst.ini, I was able to find the correct value for my installation, which is "ODBC Driver 13 for SQL Server". I don't know where the relevant string would be on a Windows or Mac system, but I suspect someone does. -- Edit bug report at https://bugs.php.net/bug.php?id=74754&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74754&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74754&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74754&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=74754&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=74754&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=74754&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=74754&r=needscript Try newer version: https://bugs.php.net/fix.php?id=74754&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=74754&r=support Expected behavior: https://bugs.php.net/fix.php?id=74754&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=74754&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=74754&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=74754&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74754&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=74754&r=dst IIS Stability: https://bugs.php.net/fix.php?id=74754&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=74754&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=74754&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=74754&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=74754&r=mysqlcfg