{"id":114,"date":"2017-03-07T12:14:26","date_gmt":"2017-03-07T09:14:26","guid":{"rendered":"http:\/\/antyat.ru\/?p=114"},"modified":"2017-03-07T12:14:26","modified_gmt":"2017-03-07T09:14:26","slug":"how-to-install-microsofts-sql-server-driver-for-php","status":"publish","type":"post","link":"http:\/\/antyat.ru\/?p=114","title":{"rendered":"How to install Microsoft’s SQL Server Driver for PHP"},"content":{"rendered":"

There are questions on Microsoft’s SQL Server driver for PHP forum<\/a> from people that cannot work out how to install the PHP driver.<\/p>\n

PHP offers some help on choosing extensions here:\u00a0http:\/\/php.net\/manual\/en\/install.pecl.windows.php<\/a>, and here: http:\/\/php.net\/manual\/en\/install.windows.extensions.php<\/a>.<\/p>\n

It’s still a bit complicated, so here are some explicit instructions which I hope can help new users of PHP.\u00a0 After a while all of this will become common sense.<\/p>\n

<\/a><\/p>\n

Instruction notes:<\/p>\n

    \n
  1. Microsoft’s PHP driver for SQL Server only runs with PHP 32-bit builds (as standard from http:\/\/windows.php.net\/download<\/a>).<\/li>\n
  2. These instructions are only for PHP 5.2, 5.3 or 5.4. (5.5 and 5.6 supported with custom build.)<\/li>\n
  3. I am pretending that PHP is installed into folder C:\\PHP.\u00a0 Replace the term C:\\PHP in the instructions with whatever folder your PHP is installed into.<\/li>\n
  4. See orange text for PHP 5.5 and 5.6\u00a0support in 32 and 64 bits. \u00a0If you do not know whether you have 64-bit PHP 5.5\/5.6, start the instructions at step 5, note the orange comment in 5.3, then return to step 1 of the instructions below.<\/li>\n<\/ol>\n

    Instructions:<\/p>\n

      \n
    1. Download Microsoft’s PHP drivers.\u00a0 Open page: http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=20098<\/a>\n
        \n
      1. If you have Windows Vista, Server 2008 or above, download SQLSRV30.EXE.<\/li>\n
      2. If you have Server 2003\/Windows XP or below, download SQLSRV20.EXE<\/li>\n
      3. If you have PHP 5.5\/5.6, or you have Windows XP\/2003 and you want to install driver 3.0…<\/i>\n
          \n
        1. See this post: Unofficial php_sqlsrv 3.0<\/a> and download the archive<\/i><\/li>\n
        2. Note the text in orange in step (2.) below — you don’t need to extract the ‘source code’ folder. \u00a0Also…<\/i>\n
            \n
          1. If you have 64-bit PHP, you need to extract only<\/u> the files in sub-folder x64<\/b>\u00a0of the zip file, and can ignore everything else.<\/i><\/li>\n
          2. If you have 32-bit PHP, you should ignore the folder x64<\/b>\u00a0in the zip file.<\/i><\/li>\n<\/ol>\n<\/li>\n
          3. Assume for step (6.) below that you downloaded\u00a0SQLSRV30.EXE<\/b><\/i><\/li>\n
          4. Remember that PHP 5.5+ does not work on Windows XP\/2003 — for this OS you can only go up to PHP 5.4.
            \n<\/i><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
          5. Extract the entire contents of the file downloaded in (1.) to your PHP extensions folder.\u00a0 This is usually a sub-folder of the location where php is installed, named ‘ext’, e.g. C:\\PHP\\ext.
            \nNote that you can use             WinRAR<\/a> to open the .exe file and extract the files, if you want.<\/p>\n

            For users of the\u00a0Unofficial php_sqlsrv 3.0<\/a>\u00a0zip file:<\/i><\/p>\n

              \n
            1. If you have 64-bit PHP, please extract only the contents of folder x64 <\/b>of the zip file.<\/i><\/li>\n
            2. If you have 32-bit PHP, extract the files in the root of the zip and ignore any folders.
              \n<\/i><\/li>\n<\/ol>\n<\/li>\n
            3. Download the SQL Server Native Client (SNAC), the PHP driver depends on it:\n
                \n
              1. For SQLSRV30.EXE (Windows Vista and above), go here: http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=29065#SNAC<\/a>. \u00a0These are direct links<\/b>:\n
                  \n
                1. SQL Server 2012 Native Client for 64 Bit Windows<\/a>\u00a0(x64)<\/li>\n
                2. SQL Server 2012 Native Client for 32 Bit Windows<\/a>\u00a0(x86)<\/li>\n<\/ol>\n<\/li>\n
                3. For SQLSRV20.EXE (Windows XP\/2003), go here: http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=16978#SNAC<\/a>. \u00a0Here are the direct links<\/b>:\n
                    \n
                  1. SQL Server 2008r2 Native Client for 64 Bit Windows<\/a> (x64)<\/li>\n
                  2. SQL Server 2008r2 Native Client for 32 Bit Windows<\/a> (x86)<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n
                  3. Install the SQL Server Native Client downloaded from the previous step (3.) on the same computer that runs PHP.<\/li>\n
                  4. Find out which version of PHP you have (if you already know it, go to step 6):\n
                      \n
                    1. Open a command window (run cmd.exe)<\/li>\n
                    2. Using your PHP folder, run command: «C:\\PHP\\php.exe» -i | more
                      \n‘more’ loads the information page by page.<\/i><\/li>\n
                    3. The top line will show PHP Version => 5.x.x…<\/i>\u00a0 Make a note of the version.\u00a0 It will start with 5.6, 5.5, 5.4, 5.3 or 5.2.\u00a0 The final (3rd) number is not important.PHP 5.5+ users can also tell if they have a 64-bit or 32-bit version of PHP by looking at the reported Architecture<\/b><\/i>:\u00a0x86<\/b> = 32-bit<\/b> and x64<\/b> = 64-bit<\/b>.For the next steps you may need to scroll to the 2nd information page in the console window, by pressing the space bar…<\/i><\/li>\n
                    4. For version 5.6, 5.5, 5.4 and 5.3<\/i><\/b>, a little further down is setting PHP Extension Build => API…<\/i> It will end with either …TS,VCn or …NTS,VCn.\u00a0 Make a note of whether it says TS or NTS.\u00a0 Also make a note of whether the final part is VC11, VC9 or VC6 (VC6 is still possible with PHP 5.3 and SQLSRV20.EXE).<\/li>\n
                    5. For PHP version 5.2 only<\/i><\/b>: note the setting that says «Thread Safety enabled» or «Thread Safety disabled».
                      \n«Thread Safety enabled» means TS,VC6
                      \n«Thread Safety disabled» means NTS,VC6.<\/li>\n<\/ol>\n<\/li>\n
                    6. Edit your php configuration file, php.ini.\u00a0 Go to the end of the file and add these lines, depending on your earlier choices.\u00a0 You need to know your PHP version number (5.2, 5.3, 5.4, 5.5\u00a0or 5.6), and your TS\/NTS setting, and whether you have a VC11, VC9 or VC6 build, all noted from step 5. above.\n

                      You can calculate the files you need by looking at the file name and comparing to your PHP version, and remembering whether you downloaded SQLSRV20.exe or SQLSRV30.exe.\u00a0 Here are all of the combinations that are possible:<\/p>\n

                        \n
                      • For the custom drivers, PHP 5.6, NTS, VC11 add lines:\n
                        extension=php_sqlsrv_56_nts.dll
                        \nextension=php_pdo_sqlsrv_56_nts.dll<\/div>\n<\/li>\n
                      • For the custom drivers, PHP 5.6, TS, VC11 add lines:\n
                        extension=php_sqlsrv_56_ts.dll
                        \nextension=php_pdo_sqlsrv_56_ts.dll<\/div>\n<\/li>\n
                      • For the custom drivers, PHP 5.5, NTS, VC11 add lines:\n
                        extension=php_sqlsrv_55_nts.dll
                        \nextension=php_pdo_sqlsrv_55_nts.dll<\/div>\n<\/li>\n
                      • For the custom drivers, PHP 5.5, TS, VC11 add lines:\n
                        extension=php_sqlsrv_55_ts.dll
                        \nextension=php_pdo_sqlsrv_55_ts.dll<\/div>\n<\/li>\n
                      • For SQLSRV30.EXE (or the custom drivers), PHP 5.4, NTS, VC9 add lines:\n
                        extension=php_sqlsrv_54_nts.dll
                        \nextension=php_pdo_sqlsrv_54_nts.dll<\/div>\n<\/li>\n
                      • For SQLSRV30.EXE (or the custom drivers), PHP 5.4, TS, VC9 add lines:\n
                        extension=php_sqlsrv_54_ts.dll
                        \nextension=php_pdo_sqlsrv_54_ts.dll<\/div>\n<\/li>\n
                      • For SQLSRV30.EXE (or the custom drivers), PHP 5.3, NTS, VC9 add lines:\n
                        extension=php_sqlsrv_53_nts.dll
                        \nextension=php_pdo_sqlsrv_53_nts.dll<\/div>\n<\/li>\n
                      • For SQLSRV30.EXE (or the custom drivers), PHP 5.3, TS, VC9 add lines:\n
                        extension=php_sqlsrv_53_ts.dll
                        \nextension=php_pdo_sqlsrv_53_ts.dll<\/div>\n<\/li>\n
                      • For SQLSRV20.EXE, PHP 5.3, NTS, VC9 add lines:\n
                        extension=php_sqlsrv_53_nts_vc9.dll
                        \nextension=php_pdo_sqlsrv_53_nts_vc9.dll<\/div>\n<\/li>\n
                      • For SQLSRV20.EXE, PHP 5.3, NTS, VC6 add lines:\n
                        extension=php_sqlsrv_53_nts_vc6.dll
                        \nextension=php_pdo_sqlsrv_53_nts_vc6.dll<\/div>\n<\/li>\n
                      • For SQLSRV20.EXE, PHP 5.3, TS, VC9 add lines:\n
                        extension=php_sqlsrv_53_ts_vc9.dll
                        \nextension=php_pdo_sqlsrv_53_ts_vc9.dll<\/div>\n<\/li>\n
                      • For SQLSRV20.EXE, PHP 5.3, TS, VC6 add lines:\n
                        extension=php_sqlsrv_53_ts_vc6.dll
                        \nextension=php_pdo_sqlsrv_53_ts_vc6.dll<\/div>\n<\/li>\n
                      • For SQLSRV20.EXE, PHP 5.2, NTS, VC6 add lines:\n
                        extension=php_sqlsrv_52_nts_vc6.dll
                        \nextension=php_pdo_sqlsrv_52_nts_vc6.dll<\/div>\n<\/li>\n
                      • For SQLSRV20.EXE, PHP 5.2, TS, VC6 add lines:\n
                        extension=php_sqlsrv_52_ts_vc6.dll
                        \nextension=php_pdo_sqlsrv_52_ts_vc6.dll<\/div>\n<\/li>\n<\/ul>\n<\/li>\n
                      • Restart your web server for the change to take effect. \u00a0That means stop and start IIS, Apache, or whatever you use, not the whole computer.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

                        There are questions on Microsoft’s SQL Server driver for PHP forum from people that cannot work out how to install the PHP driver. PHP offers some help on choosing extensions here:\u00a0http:\/\/php.net\/manual\/en\/install.pecl.windows.php, and here: http:\/\/php.net\/manual\/en\/install.windows.extensions.php. It’s still a bit complicated, so here are some explicit instructions which I hope can help new users of PHP.\u00a0 After […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-114","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts\/114","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=114"}],"version-history":[{"count":1,"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions"}],"predecessor-version":[{"id":115,"href":"http:\/\/antyat.ru\/index.php?rest_route=\/wp\/v2\/posts\/114\/revisions\/115"}],"wp:attachment":[{"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=114"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=114"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/antyat.ru\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}